Printing Problems

How to Print Only Excel Rows That Contain Numbers

Steve K Sep 28, 2026 869 views

Question details

The user wants to print only the rows in a spreadsheet that contain numerical quantities, excluding blank or non-numerical rows from the final printed page.

How to Print Only Excel Rows That Contain Numbers

Product: Excel
Device & OS: not provided
Scenario: Printing a specific list, such as a shopping list or inventory sheet, where only rows with a defined numerical quantity should be included on the paper.
Observed behavior: Without formatting or filtering, Excel prints all rows in the active sheet, resulting in blank or irrelevant rows appearing in the final output.

Before you start

Ensure your spreadsheet has clear, distinct header names at the top of your columns, as this will be required to properly apply data filters.

Solution 1Recommended

Filter Rows and Set Print Area

The most reliable method to print only rows with numbers is to filter the data first, select the visible rows, and then set them as your print area.

By applying a filter, you can hide all rows that are blank or contain text instead of numerical quantities. Setting the print area guarantees that Excel only processes these visible rows when sending the document to the printer.

Apply a filter to your data

Select the column header that contains the quantities or numbers. Go to the Data tab on the top ribbon and click on 'Filter'.

Filter for numerical values

Click the newly appeared filter dropdown arrow on the numbers column. Uncheck '(Blanks)' or apply a Number Filter (such as 'Greater Than 0') so that only rows with numerical values remain visible.

Set the Print Area

Select all the visible, filtered rows you want to print. Navigate to the 'Page Layout' tab, click on 'Print Area', and select 'Set Print Area'.

Print the document

Open the 'File' menu and select 'Print'. Ensure your print settings are configured to print the defined print area, then click the Print button.

Alternative Print Setting: Instead of setting a Print Area, you can simply highlight the filtered rows, go to File > Print, and under Settings, choose 'Print Selection'.

Easily Filter and Print Data with WPS Spreadsheet

WPS Spreadsheet provides intuitive filtering and printing features that make it incredibly simple to extract and print only the rows you need, such as those with specific numerical quantities.

1. Open your file in WPS: Launch WPS Office and open your spreadsheet file.
2. Apply Data Filter: Highlight your header row, go to the 'Data' tab, and click the 'AutoFilter' button.
3. Filter by Numbers: Click the dropdown arrow on your target column and choose 'Number Filter' to display only numerical values, hiding all blanks.
4. Print the Selection: Highlight the remaining filtered rows, press Ctrl+P to open the print dialog, and select 'Print Selection' to print exactly what you see.

Completely free and lightweight spreadsheet softwareSeamlessly compatible with Microsoft Excel (.xlsx) formatsIntuitive AutoFilter and Print Area configuration settingsAdvanced print preview mode to guarantee perfect page layout before printing

Frequently Asked Questions

How do I clear the print area after I finish printing?

To remove the print area and return to printing the entire sheet, go to the 'Page Layout' tab, click on 'Print Area', and select 'Clear Print Area' from the dropdown menu.

Can I print non-adjacent rows that contain numbers without filtering?

Yes. You can hold down the Ctrl key (or Cmd on Mac) while clicking and dragging to select specific, non-adjacent rows. Once selected, go to File > Print and change the setting to 'Print Selection'.

Why are my blank rows still printing after I filtered them?

This usually happens if your print settings are overriding the selection. Make sure you have either set the 'Print Area' specifically for the visible rows or selected 'Print Selection' in the print dialog instead of 'Print Active Sheets'.

Document & File Issues