| 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. |
| 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 | |||
Threaded Mode
