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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 03:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com