format differnet widths columns and rows for different pages

[Spear Ruler]

I would like to know how you can have different formatting for row and colunm
widths on different pages; is this possible and if so how do you do it??

[Dnereb]

You could use VBA to change the column.width for a worksheet.....
if you were talking about that?

[Gord Dibben]

By "pages" do you mean printed pages on one worksheet?

On each Excel worksheet the column width and row height are a property of the
entire column or row and cannot have differing width or height in seperate
areas of the sheet.

Exception to the rule........

You can "merge" cells to achieve this, but the disadvantages of working
with/around merged cells most times outweighs the advantages.


Gord Dibben Excel MVP

On Sat, 19 Nov 2005 05:31:03 -0800, "Spear Ruler" <Spear
[email protected]> wrote:

>I would like to know how you can have different formatting for row and colunm
>widths on different pages; is this possible and if so how do you do it??