• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hide a Column from all Users

SelvamNarayanan

New Member
I have an Excel File. Column A to Column J. Is there a way to hide Col F & Col G from all Users who have access to this Excel File
What I do now is I have to delete Col F & Col G before I share the Excel Files with my colleagues.
Once they have seen the file, I need to re-insert Col F & Col G
I was hoping there is an easier way to do this
Thank you
 
You can hide those columns by selecting those headers and with right click select hide.
Screenshot 2024-01-24 at 09.49.54.png
or
You could set column width to zero to hide those.
But
if Your hide means something else
... then please explain more about it (hiding).
 
If your users are not going to be modifying the workbook, you could hide the columns and then protect the workbook. But, keep in mind, excel is not as secure as you might think. A sharp user could unprotect the workbook and then unhide the columns if they could determine your password and are determined to do so.
 
Back
Top