Excel Guides

Printing Multiple Selections in Excel

Printing multiple selections in Excel can be a bit of a challenge, but there are a few different ways that you can go about it.

One way is to use the print area feature. To do this, first select the cells that you want to print. Then, go to File > Print Area > Set Print Area. This will highlight the selected cells in blue so you can see what will be printed. Finally, click File > Print and make sure that the Print Selection option is selected.

Another way to print multiple selections in Excel is to use the page break feature. To do this, first select the cells that you want to print. Then, go to Insert > Page Break. This will insert a dotted line above and below the selected cells, indicating where the page will break when printed. Finally, click File > Print and make sure that the Fit Sheet on One Page option is selected.

Finally, you can also use the print titles feature to print multiple selections in Excel. To do this, first select the cells that you want to print. Then, go to File > Page Setup and click on the Sheet tab. In the Print Titles section, click on the button next to Rows to repeat at top and enter the row numbers that you want to repeat at the top of each page (e.g., 1-3 if you want rows 1-3 to be printed at the top of each page). Then click OK. Finally, click File > Print and make sure that the Repeat Row Titles option is selected.

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.