ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   height and width settings locked? (https://www.excelbanter.com/excel-discussion-misc-queries/48733-height-width-settings-locked.html)

Lab Teacher

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?

Jim Rech

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?



JR

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?


julesofmooney

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