Software

General discussion

Locked

locking width of excel column

By bob_markovic ·
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...

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

locking width of excel column

by DKlippert In reply to locking width of excel c ...

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.

Related Discussions

Related Forums