different formats on one sheet

  • Thread starter Thread starter RobcPettit
  • Start date Start date
R

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
 
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.
 
Back
Top