#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Setting Page Setup

I have spreadsheets that I need to print that are in columns that are side by
side. They will not all fit on one page and they differ in length. How do I
set the print boundries to enable these sheets to be printed correctly? When
I set the verticle Page break it stay on the same row across the whole spreat
sheet. Due to this some of the sheets are cut in half?
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Setting Page Setup

make your left and right margins smaller
use landscape mode
on page setup, use the Fit to option

"Newt" wrote:

I have spreadsheets that I need to print that are in columns that are side by
side. They will not all fit on one page and they differ in length. How do I
set the print boundries to enable these sheets to be printed correctly? When
I set the verticle Page break it stay on the same row across the whole spreat
sheet. Due to this some of the sheets are cut in half?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Setting Page Setup

I have two different spread sheets I need to print and they are side by side.
I need to use the portrait mode. The spread sheets are different lengths.

"dlw" wrote:

make your left and right margins smaller
use landscape mode
on page setup, use the Fit to option

"Newt" wrote:

I have spreadsheets that I need to print that are in columns that are side by
side. They will not all fit on one page and they differ in length. How do I
set the print boundries to enable these sheets to be printed correctly? When
I set the verticle Page break it stay on the same row across the whole spreat
sheet. Due to this some of the sheets are cut in half?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,290
Default Setting Page Setup


You can paste into Word and use Format | Columns
-or -
Build your own method...
http://www.mvps.org/dmcritchie/excel....htm#snakecols
-or -
Use a commercial add-in... (see below)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming - try "Special Print")



"Newt"
wrote in message
I have spreadsheets that I need to print that are in columns that are side by
side. They will not all fit on one page and they differ in length. How do I
set the print boundries to enable these sheets to be printed correctly? When
I set the verticle Page break it stay on the same row across the whole spreat
sheet. Due to this some of the sheets are cut in half?
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
setting page setup/print area for multiple sheets [email protected] Excel Discussion (Misc queries) 6 October 27th 07 01:19 PM
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE Randy Excel Worksheet Functions 1 February 8th 07 06:15 PM
Default Setting to 1 Page by 1 Page Doug Excel Discussion (Misc queries) 1 January 22nd 07 09:18 PM
Under Page Setup the page option of Ledger - for Office XP Turbo Excel Discussion (Misc queries) 2 September 27th 06 02:46 AM
setting Page Setup on a workbook level [email protected] Excel Discussion (Misc queries) 1 June 14th 06 06:07 PM


All times are GMT +1. The time now is 01:44 PM.

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

About Us

"It's about Microsoft Excel"