Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect unlocked cells in a protected worksheet from cut/pasting | Excel Discussion (Misc queries) | |||
Protecting Workbook | Excel Discussion (Misc queries) | |||
Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) | |||
Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions |