Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rjoshi
 
Posts: n/a
Default printing workbook -landscap in to portrait format in Excel

One of my financial program generates Excel workbook (with about 10
worksheets). they all show up in Landscap format. When printing I would like
to print in Portrait format. Is there an easy way to print entire workbook in
Portrait without changing each worksheet format?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Select all sheets (click first tab, hold down shift and click last tab), do
the page setup, then ungroup the sheets


Regards,

Peo Sjoblom


"rjoshi" wrote:

One of my financial program generates Excel workbook (with about 10
worksheets). they all show up in Landscap format. When printing I would like
to print in Portrait format. Is there an easy way to print entire workbook in
Portrait without changing each worksheet format?

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
Change format to landscape for whole workbook at once hw Excel Worksheet Functions 1 April 29th 05 05:08 AM
printing workbook Lisa Excel Discussion (Misc queries) 1 March 9th 05 03:31 PM
Copying the format within a worksheet to all in a workbook Ian Wormald Excel Discussion (Misc queries) 1 February 23rd 05 02:19 PM
How do I format all worksheets in a workbook at one time ? EBrock Excel Discussion (Misc queries) 3 February 9th 05 06:45 AM
format a 29 sheet workbook JennB Excel Discussion (Misc queries) 4 December 8th 04 01:09 AM


All times are GMT +1. The time now is 09:33 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"