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.
 
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

Column widths in Excel 2013 16
Possible to select a string in a locked cell? 1
Help Needed ... Probably simple for you gurus ... locking cell afterdata entered and 1
column width lock 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Inserting cells (shift cells right) using macro 0
Filter on sheet with some cells protected? 9
Oh god someone help me please. This is ridiculous. 1

Back
Top