How do I freeze the widths of columns?

S

SuzyR

I'm trying to freeze the widths of columns so that when users of the
worksheet are using it, they can't change the width. It's for editors who
write headlines for specific areas that can only be as long as the column is
wide or the text won't fit.
 
G

Guest

One way is to right click on the cell, select 'format
cells', select the 'allignment' tab, and select the 'wrap
text' check box.

The other way is to select 'format', 'column' and 'width'.
This will not wrap the text but will keep the column at the
width you specify.

Hope this helps!

Angelo
 
P

Paul B

Suzy, how about just protecting the worksheet, you cannot change the widths
then
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top