| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you lock cells - the format - but still allow data entery?
Especailly dragging and C&P to fill the cells?
Marc |
|
#2
|
|||
|
|||
|
Try selecting the cell
and then from the Data menu select validation this gives you a list of entries that can be made into that cell "Marc" wrote in message ink.net... Especailly dragging and C&P to fill the cells? Marc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
| Format cells as date | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Linear Mode
