different formats on one sheet

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need macro to move cell contents from one sheet to another 1
Problem laying out pages with divs or asp:table 3
Applying difference page sizes in a single PPT file (multiple slidesizes) 3
Excel worksheet - Can I make changes in one sheet affect contents of other sheet? 3
Coulmn widths different between 2 files? 1
Subreports Separating to Different Pages When Printing 2
Page format for Calculation Sheet 1
Dynamic controls 5

Top