 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008How 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 Select sheet2 then hold SHIFT key and click on sheet9 File>Print>Active Sheet(s) Gord Dibben MS Excel MVP >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 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 FILE>PRINT>ACTIVE SHEET(S). CTRL allows you to select multiple sheets in ant order.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.