Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Print mult worksheets to Adobe | Excel Discussion (Misc queries) | |||
How can I print a specified page from several worksheets in Exce. | Excel Worksheet Functions | |||
Can I create a cell that will count by one every time I print the. | Excel Worksheet Functions | |||
Print several worksheets at once with fewer pages | Excel Discussion (Misc queries) |