Lock columns

M

Maria K Brickl

I have this excel spreadsheet that I need to distribute to people to use to
fill in but because I need to convert this spreadsheet to a specific format
once they send it back to me I don't want them to be able to change the
column width. Is there a way to lock the column width but still have people
be able to enter data and be able to still use the tab key to move from cell
to cell?
 
K

Ken Wright

CTRL+A / Format / cells / Protection / Uncheck Locked. Then Tools / Protection
/ Protect Sheet - password optional.
 
Top