Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 108
Default different formats on one sheet

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default different formats on one sheet

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Too Many differnt Cell Formats in excel sheet Bishnu Excel Discussion (Misc queries) 2 July 7th 09 06:03 PM
Too Many differnt Cell Formats in excel sheet Bishnu[_2_] Excel Discussion (Misc queries) 0 July 7th 09 04:48 PM
copy a sheet with all formats - column widths, etc? Rich Excel Programming 2 April 26th 05 09:10 PM
Copying formulas, formats, and sheet names across workbooks Kevin H. Stecyk[_2_] Excel Programming 7 August 22nd 04 09:50 PM
Create master sheet RETAIN formats Brenda[_6_] Excel Programming 2 December 10th 03 07:50 PM


All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"