Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Lock the format
I have a spreadsheet that I need others to update with values. I want them
to be able to enter text, but not modify the formatting (column width, font, etc). They may need to add additional rows, though. But still do not want them to be able to modify the format of those new rows. Seems like I should be able to do this, but I can't figure out how. Thanks in advance. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Lock the format
By default all cells in a worksheet are locked when sheet protection is
enabled. It is up to you to decide which are to be locked or unlocked when the sheet is protected. FormatCellsProtection is where you would change the "locked" or "unlocked" status. Select all cells and unlock them. Select the cells to be locked and lock them Then ToolsProtectProtect Sheet. Note the selectable options under "allow users to" when protecting, specifically allowing inserting rows. Note that "Format Cells" can be disallowed by leaving it unchecked. Gord Dibben MS Excel MVP On Wed, 20 May 2009 12:50:02 -0700, DaveL wrote: I have a spreadsheet that I need others to update with values. I want them to be able to enter text, but not modify the formatting (column width, font, etc). They may need to add additional rows, though. But still do not want them to be able to modify the format of those new rows. Seems like I should be able to do this, but I can't figure out how. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Any way to Lock format but not the values? | Excel Discussion (Misc queries) | |||
Conditional Format To Lock Cell | Excel Discussion (Misc queries) | |||
How do you lock cells - the format - but still allow data entery? | New Users to Excel | |||
Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel |