Software

Ask something
Discussion Locked

locking width of excel column

0 helpful
1 reply

by bob_markovic

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I "lock" the width of an Excel spreadsheet column so a user cannot 'stretch' to make it bigger? It screws up the report formatting. Thanks...

1 reply

by dklippert

Tools>Protection Protect sheet.
If you want certain cells to be unprotected for data entry, select them and go to Format Cells Protection and remove the Locked check mark.

This discussion is closed to new replies.