This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
How do I hide columns then allow someone else to use the spreadsheet without them being able to unhide the columns I don't want them to see?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Use Protect Workbook feature from Review Tab. It will not allow users to play with the structure of workbook.
Thank you. I triEd this but the columns could still be unbidden.
Yes, you are right. By that command, you control Sheet structure, one can not unhide sheets.
For your issue, What I will suggest, use Protect sheet command which is in review tab. Once you protect the sheet, it will not allow user to unhide columns. In case you want user to work on other columns/cells, then before protecting sheet, make other column/cells as Unlocked by going to cell format, last tab "Protection". Here you have to uncheck the Locked command.
See this snip shot.