Excel Guides

Printing Multiple Worksheet Ranges in Excel

Printing multiple worksheet ranges in Excel can be a bit of a challenge, but it is definitely possible. Here are some tips to help you get started:

  1. First, you'll need to select the ranges that you want to print. To do this, hold down the Ctrl key and click on each range. Once all of the ranges are selected, right-click on one of them and choose Print from the menu.
  2. In the Print dialog box, make sure that the Selection radio button is selected in the What to print section.
  3. Now, click on the Settings button. In the Page Setupdialog box, go to the Sheet tab. In the "Print" area, select the option for "Rows to repeat at top" (this will be located under the "Headings" section). This will allow you to specify which rows will be printed at the top of each page.
  4. Click on the row that you want to print at the top of each page and then click on the Add button. You can add multiple rows if necessary. Once you're done, click on the OK button.

  5. Now, click on the Preview button in the lower left corner of the dialog box. This will allow you to see how your printout will look. If everything looks good, click on the OK button.

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.