Excel Guides

Showing Filter Criteria on a Printout in Excel

When printing an Excel worksheet, it is often useful to show the filter criteria that was used to generate the printout. This can be accomplished by following these steps:

  1. Open the worksheet that you want to print.
  2. Click the File tab, and then click Print.
  3. Under Settings, click Print entire workbook.
  4. Click the Options button.
  5. In the Print dialog box, under Print what, select Filtered data.
  6. Click OK.

Now when you print the worksheet, the filter criteria will be displayed at the top of each page.

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.