Column width change in large spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 **
Heather Claire said:
I have a large spreadsheet with formulae connecting cells. I am required
Click to expand...
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?
 
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
 
Back
Top