different formats on one sheet

[RobcPettit]

Hi, Hope get my idea accross. On a sheet I have a layout sized to 1
page(re priting). The columns are different widths, colA through to
colE. The rest a standard width. So, thats page 1 on the sheet. Now
can I design page 2 on the same sheet, with colomns bieng a different
width to the first page. Also if say, Ive copyied my first pages
layout and pasted underneath, crearing say, another 5 pages, can I use
a command to select the start of each page.
Regards Robert

 

[JLGWhiz]

You could get into using merged cells or setting borders to simulate expanded
columns, etc. However, it would probably be easier to just use separate
sheets if your page layout will vary greatly in column widths. Excel does
not lend itself to multiple page formats on one worksheet for printing
purposes.