Changing colum width within the same page?

G

Glenn Jones

Is there any way to change the column widths within the
same page in an Excel worksheet? I need to create a box
that has 6 columns the same size on the top of the page (5
rows high) and then the rest of the page I need the first
column to be very thin and then a very large column
followed by a small column. I can't - for the life of me -
figure out how I can create A through F columns that are
12 points wide on the top of a page and then have it
change to A being 4 points wide B being 54 points wide anc
C being 10 points wide. Is this at ALL possible? I have
Excel for Office 2003. Thanks in advance.
 
D

David McRitchie

Hi Glenn,
With that much difference, I doubt that you would need to
sort, because when you merge columns you can't sort.

You cannot change the width of a column on a worksheet.
You can make narrower columns and merge them.

use the merge across to merge cells row by row

use the merge cels if you want to merge cell on on more
than one row into a cell.

Manually: Format, cells, alignment, horizontal and merge options

Formatting Toolbar Icons
-- Merge and Center -- customize, commands, format
-- Merge Across -- customize, commands, format
-- Merge Cells -- customize, commands, format
-- Unmerge Cells -- customize, commands, format

to see the actual toolbar buttons see
see Merge and Unmerge Cells
http://www.mvps.org/dmcritchie/excel/merge.htm#builtin

Merging of cells interfers with sorting, filtering, copying, and pasting
along with interferring with autofit of row height and column widths
 
Top