Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Protecting all worksheets of a workbook | Excel Discussion (Misc queries) | |||
How to set print range for a number of worksheets | Excel Discussion (Misc queries) | |||
What is the simplest way to print multiple worksheets? | Charts and Charting in Excel | |||
how can I get all worksheets to print at one time? | Excel Worksheet Functions |