Excel Guides

Printing Only Selected Pages in Excel

If you only want to print selected pages in Excel, there are a few different ways that you can go about doing this. One way is to use the Page Layout view. To do this, first make sure that your worksheet is in Page Layout view by going to the View tab and selecting Page Layout from the drop-down menu. Then, click on the Page Setup group and select Print Area. In the Print Area dialog box, select the cells that you want to print. You can also specify which pages you want to print by entering the page numbers in the Pages text box. Once you have everything set up the way you want it, click OK and then click on the File tab and select Print from the drop-down menu.

Another way to print only selected pages in Excel is to use the Print dialog box. To do this, first click on the File tab and then select Print from the drop-down menu. In the Print dialog box, select Selected Sheets from the Print What drop-down menu. Then, click on the Selection button and select the cells that you want to print. You can also specify which pages you want to print by entering the page numbers in the Pages text box. Once you have everything set up how you want it, click OK.

You can also use VBA code to print only selected pages in Excel. To do this, first open your workbook in Excel and press Alt+F11 to open the Visual Basic Editor. Then, insert a new module by clicking on Insert > Module. In the module, enter the following code:

Sub PrintSelectedPages()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Name = "Sheet1" Or ws.Name = "Sheet3" Then
ws.PrintOut Copies:=1, Collate:=True
End If
Next ws
End Sub

This code will print out Sheet1 and Sheet3 of your workbook.

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.