Excel Guides

Setting Print Ranges for Multiple Worksheets in Excel

There are a few different ways that you can set print ranges for multiple worksheets in Excel. One way is to select the worksheets that you want to print, and then click the Page Layout tab. In the Page Setup group, click Print Area, and then click Set Print Area. This will open the Page Setup dialog box. In the Print Area section, click the worksheet tab for each worksheet that you want to include in the print range, and then click OK.

Another way to set print ranges for multiple worksheets is to select the worksheets that you want to print, and then click File > Print. This will open the Print dialog box. In the Settings section, click Selection: Active Sheets. Then, click Print.

You can also use VBA to set print ranges for multiple worksheets. The following code will select all of the worksheets in a workbook and set their print ranges:

Sub SetPrintRanges()
    Dim ws As Worksheet

    For Each ws In ActiveWorkbook.Worksheets
        ws.PageSetup.PrintArea = "$A$1:$IV$65536"
    Next ws
End Sub

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.