| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I print only select sheets in my workbook?
My workbook has 12 sheets, but I want to print the second through ninth sheet
exclusively, each time I hit print. (I do this once a week.) How do I do it? Excel 2007 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can I print only select sheets in my workbook?
Select sheet2 then hold SHIFT key and click on sheet9
FilePrintActive Sheet(s) Gord Dibben MS Excel MVP On Thu, 27 Mar 2008 19:14:00 -0700, MVictoreen wrote: My workbook has 12 sheets, but I want to print the second through ninth sheet exclusively, each time I hit print. (I do this once a week.) How do I do it? Excel 2007 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How can I print only select sheets in my workbook?
Hi MVictoreen!
As an optional method to Gord Dibben's post, you can select the sheets you want to print by holding CTRL and clicking the sheets you want to print, the go to FILEPRINTACTIVE SHEET(S). CTRL allows you to select multiple sheets in ant order. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to select and print sheets | Excel Discussion (Misc queries) | |||
| Print Macro both sheets at once with option to select days etc | Excel Worksheet Functions | |||
| How do I print two sheets in same workbook duplex? | Excel Worksheet Functions | |||
| Formatting all sheets in a workbook to print the same | Excel Discussion (Misc queries) | |||
| How do I print all sheets of an Excel workbook from explorer? | Excel Discussion (Misc queries) | |||
Linear Mode
