| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
height and width settings locked?
Can row height and column width settings be locked in an Excel document
without blocking the user from entering/editing data in the cells? |
|
#2
|
|||
|
|||
|
Only by the usual mechanism of unlocking the data entry cells, which could
be all the cells. -- Jim "Lab Teacher" <Lab wrote in message ... | Can row height and column width settings be locked in an Excel document | without blocking the user from entering/editing data in the cells? |
|
#3
|
|||
|
|||
|
Click the button between row 1 and column A to select the entire worksheet,
then right click and go to format. Go to the protection tab and unprotect. Then go to tools, protection, protect sheet. "Lab Teacher" wrote: Can row height and column width settings be locked in an Excel document without blocking the user from entering/editing data in the cells? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
height and width settings locked?
"JR" wrote: Click the button between row 1 and column A to select the entire worksheet, then right click and go to format. Go to the protection tab and unprotect. Then go to tools, protection, protect sheet. "Lab Teacher" wrote: Can row height and column width settings be locked in an Excel document without blocking the user from entering/editing data in the cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vary column width and row height in the same worksheet | Excel Discussion (Misc queries) | |||
| Is it possible to lock the height and width of a cell? | Excel Discussion (Misc queries) | |||
| Can I make column width and row height equal (a grid) in Excel? | Excel Discussion (Misc queries) | |||
| Is it possible to view or size column width and/or row height in . | Excel Discussion (Misc queries) | |||
| Displaying column width and row height | Excel Worksheet Functions | |||
Linear Mode
