How to vary column widths

[tsac1234]

I have a four page worksheet and have managed to make it work with th
same column width on all four pages. However, I would like to hav
different widths on different pages. Example: column A on page 1 i
set at 11.14 and I would like column A on page 2 to be thinner, sa
10.29. Can this be done?

Thanks for your help

 

[Don Guillett]

Sure, just right click on it and set the column width or I just recorded the
macro below which can be shortened and executed from anywhere.

Sheets("Sheet2").Columns("A:A").ColumnWidth = 11.14

Sub Macro9()
'
' Macro9 Macro
' Macro recorded 7/3/2004 by Don Guillett
'

'
Sheets("Sheet2").Select
Columns("A:A").Select
Selection.ColumnWidth = 11.14
End Sub

 

[CLR]

Move the cursor up into the top heading where the A, B, C etc column letters
are and left click on the line between two adjacent columns and hold the
mouse button down and just drag it left or right to whever you want
it.........or just double click on that line and it will autosize the column
to the widest value in the column...........

Vaya con Dios,
Chuck, CABGx3

 

[tsac1234]

I don't think my question was specific enough. I was referring t
columns on the same sheet rather than two different worksheets. A
example would be on sheet1, A5 through A15 being set at 11.14 and A2
through A30 on sheet1 being set at 10.29. Is it possible to do this?

Thanks agai

 

[JE McGimpsey]

No. Width is a property of the column, not individual cells. You *can*
Merge cells in adjacent columns to get a wider cell, but I don't
recommend it since it can cause other problems, including selecting
columns.

 

[wiseman]

Perhaps you could record a macro. Print the first page, change the column
widths, print but choose only the 2nd page etc. If you were always printing
the same area and with the same column widths this may work.
Barbara