height and width settings locked?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
JR said:
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

row height 1
Need help on formatting row height 1
Row Height-Auto Adjust to Content? 5
Changing Row Height/Column Width 4
Excel 2003 Row and Column Dimensions 4
excel 2007 copy row heights 3
Auto Cell Height Adjustment for text entered 3
Calculating Row Height & Column Width 4

Back
Top