Journalism, Media Studies & Communications +.The above code uses the print area from the active sheets, goes to all the sheets in the workbook and sets the same print area in each of these sheets. Note: This method works well when you have the same range of cells that you want to use while setting the Print Area.īelow is the VBA macro code that will do this: Sub SetPrintAreas1() In that case, you can also use VBA to quickly set the print area in one sheet, and then run the code to replicate it to all the other sheets. In case you have a lot of worksheets, setting the print area manually can be time-consuming. So if you want to print specific areas in Sheet1, Sheet4, and Sheet5, you will have to do it for each sheet separately. You need to do this manually for each sheet. This would set the print area to the selected cells and when you print this sheet, only the print area will be printed. In the Page Setup group, click on ‘Print Area’.Select the cells that you want to be covered in the print area.So let me quickly show you how to set the Print area manually and using VBA. Once you have set the print area, you can then use any of the above methods to print the sheets. Or you can use a simple VBA code to set the same print area in all the sheets at one go.You need to do it manually for each sheet (especially if the print area is different for each sheet).Now when it comes to setting the print area: This can be done by setting a print area in all the sheets and then printing these (as shown in the above two methods). 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. |