ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I print a workbook in but only print selected worksheets? (https://www.excelbanter.com/excel-discussion-misc-queries/107835-how-do-i-print-workbook-but-only-print-selected-worksheets.html)

Karl S.

How do I print a workbook in but only print selected worksheets?
 
I want to print a workbook using File/Print, but I don't want to print all of
the worksheets. Is there a way to specify which worksheets will be printed
without using a macro?

Pete_UK

How do I print a workbook in but only print selected worksheets?
 
You can group the sheets you want to print. Select the first sheet then
hold down the CTRL key and select the second, third etc. Then do File |
Print Preview and you will be able to select Next (and Previous) to see
how they will look when you print them. You can ungroup the sheets by
clicking on a sheet tab that is not part of the group.

Hope this helps.

Pete

Karl S. wrote:
I want to print a workbook using File/Print, but I don't want to print all of
the worksheets. Is there a way to specify which worksheets will be printed
without using a macro?




All times are GMT +1. The time now is 04:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com