Pdf print selection8/17/2023 ![]() Maybe there is summary data in each sheet and you only want to print this data and not the entire worksheet. Suppose you have a workbook with multiple sheets, and you want to print a specific area from each sheet. This one is a little more complex than the previous two. Print Multiple Sheets With a Specific Print Area You can also change page numbers and see what will be printed on each page. You can also see what will be printed in the Print preview on the right. When you select multiple sheets, these all act as active sheets while printing. Click on Print Active Sheets (in most cases, it’s already the default option, but in case it isn’t you can choose that from the drop-down).In this example, I am selecting Sheet 1, 4 and 5 To do this, hold the Control key and select sheets one by one. Select all the sheets that you want to print.Read on! Print Multiple Sheets (Selected Ones) at One GoĪll you need to do is selected those specific sheets that you want to print and then print it!īelow are the steps to print some specific sheets in a workbook in Excel: Now, what if you only want to print only some specific sheets and not the entire workbook. In case you have a print area set in some of the sheets, then only that print area will be printed. The above steps would print all the sheets in the workbook. In the Print page, click on the Print setting drop-down.Print Multiple Sheets With a Specific Print AreaĮxcel has an inbuilt feature that allows you to specify to print all the sheets at one go.īelow are the steps to print all the sheets in the workbook:.Print Multiple Sheets (Selected Ones) at One Go.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |