Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock format but allow data entry
Is there any way to lock the format of a cell but allow users to input data?
I have a worksheet that has specific formatting in certain cells (background color, borders, fonts, # of decimals displayed,etc) but users need to be able to input data into the cells. I would like to prevent users from copying and pasting into the cells which would also potentially change the format. Thanks Irie! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock out data entry in a cell | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
lock cell conditional format but not restrict data entry | Excel Worksheet Functions | |||
Lock Row after Data Entry | Excel Discussion (Misc queries) | |||
Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel |