ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Protect cells (https://www.excelbanter.com/excel-worksheet-functions/62794-protect-cells.html)

Vanessa Simmonds

Protect cells
 
Hello,

I have a worksheet with three columns, I want to protect only two columns
and leave the other one open to be filled. How can i do it ?

Thank you very much in advance.

Roger Govier

Protect cells
 
Hi Vanessa

Mark your third column
FormatCellsProtection and reomove the tick from Locked
ToolsProtectionProtect Sheet (with or without password)
(Make a note of the password if you use one.)


--
Regards

Roger Govier



Vanessa Simmonds wrote:
Hello,

I have a worksheet with three columns, I want to protect only two
columns and leave the other one open to be filled. How can i do it ?

Thank you very much in advance.





All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com