The ability to have multiple tabs, or worksheets, in one workbook is one of the best things that ever happened to Excel. \u00a0But when you go to print, Excel normally prints the currently selected worksheet. \u00a0If you look at the options in the print dialogue, you’ll see that you can print the entire workbook if you want. \u00a0But how can you print more than one worksheet without printing the entire workbook?<\/p>\n
Then answer comes back to a common windows shortcut. \u00a0Using the shift <\/em>key while selecting objects with your mouse usually selects a range of objects. \u00a0While combing the mouse with the ctrl <\/em>key allows you to select (or de-select) multiple random objects. \u00a0When printing from Excel, you can put that to work for you by clicking on the tab for the first worksheet you want to print, then hold down the shift <\/em>key and click on the last tab that you want to print. \u00a0You will see that both tabs you clicked on, along with all the tabs in between, will be selected. \u00a0You can then use Ctrl <\/em>while clicking on tabs to add or remove tabs from that selection. \u00a0Of course you can use Ctrl <\/em>without using Shift <\/em>first. \u00a0Once you have your tabs selected, print like you normally would, but make sure that in the print dialogue you select the option to Print Active Sheets<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":" This tip shows how you can easily print more than one worksheet in Excel, even when you don’t want to print the entire workbook.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/400"}],"collection":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=400"}],"version-history":[{"count":4,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/400\/revisions"}],"predecessor-version":[{"id":617,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/400\/revisions\/617"}],"wp:attachment":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}