Column width change in large spreadsheet

[Heather Claire]

I have a large spreadsheet with formulae connecting cells. I am required to reduce the column widths of a range of cells halfway down the spreadsheet. I cannot allow the whole column to change. How do I do this?

 

[Paul B]

Heather, you can not change part of a column, your only option would be to
merge the cells for part of the column, but be aware that this option can
cause problems when you want to sort, copy and pastes and other things.

--
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 2000 & 97
** remove news from my email address to reply by email **

I have a large spreadsheet with formulae connecting cells. I am required

to reduce the column widths of a range of cells halfway down the
spreadsheet. I cannot allow the whole column to change. How do I do this?

 

[Gord Dibben]

Heather

Width is a property of the entire column and cannot be altered.

One work-around is to use the "center across selection" feature.

Gord Dibben Excel MVP

On Sun, 27 Jun 2004 08:29:01 -0700, "Heather Claire" <Heather