Locking column widths

N

Nardar

Every time I auto fit one column width, other widths in the worksheets
change. How do I lock the formatting of cells, but not the data, especially
the column widths? I'm using Excel 2003.
 
D

Dave Peterson

Unlock the cells (format|cells|Protection tab) that you want to be able to
change.

Then protect the sheet (tools|Protection|protect sheet).
 
D

David Biddulph

It shouldn't do that. How are you doing the autofit? If you select one
column and use Format/ Column/ Autofit Selection, it should change only that
column.
 

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 width of Pivot Table data goes back to default when data refreshed 2
Paste Special "All" doesn't actually do "all". 3
Column widths - strange problem 2
Pivot tables and column widths 1
having two separate column width controls on same worksheet 1
Worksheet Column Widths Different For Different Users 2
column widths keep changing in shared file 1
Automatically adjust column widths 1

Top