Lock columns

  • Thread starter Thread starter Maria K Brickl
  • Start date Start date
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?
 
CTRL+A / Format / cells / Protection / Uncheck Locked. Then Tools / Protection
/ Protect Sheet - password optional.
 
Back
Top