Protect and hide one column

  • Thread starter Thread starter KDC
  • Start date Start date
K

KDC

is it possible to hide and protect just one column. I do not want someone
even able to "unhide" a column. Thanks
 
Hide the column then protect the sheet with a password.

But take note that Excel's internal security is very weak and passwords
easily broken.

If you don't want them to see it, don't include it in the workbook.


Gord Dibben MS Excel MVP
 
Okay, I was hoping to just hide and protect the column, because I need others
to update the sheet.
 
Thank you for your response. I was hoping to just hide a column and protect
that only because I need others to update the sheet.
 
You can hide the column and unlock all cells that are to be edited then
protect the sheet.

Format>Cells>Protection for unlocking selected cells.

This will allow users to enter data in unlocked cells.

Same caveat about "weak security" applies.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hide, unhide column or row after protect worksheet 4
hidden column 1
hide columns with a "+" 2
Hide Column 2
How to unhide all? 4
Excel 2007 - Hide & Unhide Columns/Rows 8
Hide Columns and Protect cells v2003 3
To retrieve hide columns after u saved the excel doc 2

Back
Top