PC Review


Reply
Thread Tools Rate Thread

different formats on one sheet

 
 
RobcPettit
Guest
Posts: n/a
 
      16th Oct 2008
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
 
Reply With Quote
 
 
 
 
JLGWhiz
Guest
Posts: n/a
 
      16th Oct 2008
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.

"RobcPettit" wrote:

> 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
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy a sheet and all formats to a new sheet Bill Microsoft Excel Programming 3 30th Jul 2009 09:02 PM
Too Many differnt Cell Formats in excel sheet Bishnu Microsoft Excel Misc 0 7th Jul 2009 04:48 PM
How to find out the number of formats in excel sheet =?Utf-8?B?QXNod2luaQ==?= Microsoft Excel Misc 0 18th Nov 2004 08:44 AM
Finding all the Formats used in an Excel Sheet =?Utf-8?B?QnJpamVzaA==?= Microsoft Excel Misc 1 18th Nov 2004 06:43 AM
How do I transfer color formats from one work sheet to another =?Utf-8?B?S2FuZ2EgODU=?= Microsoft Excel Misc 3 16th Nov 2004 04:53 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:59 PM.