Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sofia
 
Posts: n/a
Default how can I get all worksheets to print at one time?

My workbook has 6 worksheets - Title - Notice - Balance Sheet - Retained
Earnings - Income Stmt - Notes. When I try to print the workbook - I get 2
copies of the Income Stmt, none of the Balance Sheet and 1 of everything else.

what am I doing wrong? The Balance Sheet will print by itself - but not as
part of the workbook.
  #2   Report Post  
stacyjhaskins
 
Posts: n/a
Default

First, check your print area on each page:
The easiest way to do this is go to View and Page Break Preview. Drag the
blue lines to include everything you want to print on that page.

Finally, print the entire workbook:
Go to File, Print, Select "Entire Workbook" under "Print What",
and click ok.

"Sofia" wrote:

My workbook has 6 worksheets - Title - Notice - Balance Sheet - Retained
Earnings - Income Stmt - Notes. When I try to print the workbook - I get 2
copies of the Income Stmt, none of the Balance Sheet and 1 of everything else.

what am I doing wrong? The Balance Sheet will print by itself - but not as
part of the workbook.

  #3   Report Post  
Scott
 
Posts: n/a
Default

Hi Stacy,

In addition to the previous reply, I'd also look up the feature called
"Report Manager." I believe it's an add-in that you have to download but it's
on this Microsoft site. This feature will allow you to print your entire
report with one mouse click.

"stacyjhaskins" wrote:

First, check your print area on each page:
The easiest way to do this is go to View and Page Break Preview. Drag the
blue lines to include everything you want to print on that page.

Finally, print the entire workbook:
Go to File, Print, Select "Entire Workbook" under "Print What",
and click ok.

"Sofia" wrote:

My workbook has 6 worksheets - Title - Notice - Balance Sheet - Retained
Earnings - Income Stmt - Notes. When I try to print the workbook - I get 2
copies of the Income Stmt, none of the Balance Sheet and 1 of everything else.

what am I doing wrong? The Balance Sheet will print by itself - but not as
part of the workbook.

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
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
Print mult worksheets to Adobe John Day Excel Discussion (Misc queries) 2 May 25th 05 03:54 PM
How can I print a specified page from several worksheets in Exce. jastmaine Excel Worksheet Functions 1 April 14th 05 09:27 PM
Can I create a cell that will count by one every time I print the. Tyler Hopfner Excel Worksheet Functions 1 February 7th 05 06:10 PM
Print several worksheets at once with fewer pages Stephen POWELL Excel Discussion (Misc queries) 6 January 25th 05 02:21 PM


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