How to Print Selected Ranges in Excel Without Blank Rows
Question details
The user wants to print specific data ranges from an Excel spreadsheet without printing the blank rows or intervening data between them.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Printing specific non-contiguous data ranges from a spreadsheet.
- Observed behavior
- By default, printing a selected range might include unwanted blank rows or intervening data that the user wishes to exclude from the final printed page.
Before printing, ensure your printer is properly connected and preview your document to verify which rows are currently visible in your print area.
Hide Unwanted Rows Before Printing
The simplest way to exclude blank or intervening rows from your printout is to hide them temporarily.
Click and drag the row numbers on the left side of the sheet to select the blank or intervening rows you want to exclude.
Right-click the selected row numbers and choose 'Hide' from the context menu.
Go to File > Print. The hidden rows will not appear in the print preview or the final printed document.
After printing, select the rows above and below the hidden ones, right-click, and choose 'Unhide' to restore your view.
Copy Required Ranges to a New Worksheet
If you have multiple non-contiguous ranges, copying them to a dedicated printing sheet keeps your original data intact and clean.
Use the FILTER Function to Extract Non-Blank Records
For dynamic data, use the FILTER function to automatically generate a list without blank rows for printing.
Easily Print Selected Ranges Without Blank Rows in WPS Office
WPS Spreadsheet offers intuitive printing controls, allowing you to easily hide rows, set print areas, and filter out blank data before printing. It is fully compatible with Microsoft Excel formats, offering a seamless experience.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet containing the data.
- 2. Filter or hide blank rows: Select the rows you don't want to print, right-click, and select 'Hide', or use the AutoFilter tool from the Data tab to uncheck 'Blanks'.
- 3. Set the Print Area: Highlight the data you want to print, go to the Page Layout tab, click 'Print Area', and select 'Set Print Area'.
- 4. Preview and Print: Click the Print icon or press Ctrl+P to preview your document and ensure no blank rows are included, then click Print.
Frequently Asked Questions
Can I print multiple non-adjacent selections on one page?
By default, Excel prints non-adjacent selections on separate pages. To print them on a single page, it is best to copy and paste the selections next to each other on a new worksheet, or use the Camera tool to place linked pictures of the ranges together.
How do I use the Camera tool to print specific ranges?
First, add the Camera tool to your Quick Access Toolbar from Excel Options. Highlight your first range, click the Camera tool, and click on a blank sheet to paste a live image. Repeat for other ranges, arrange the images together on the single sheet, and print that sheet.
Why are blank pages printing at the end of my Excel document?
Blank pages often print because Excel detects formatting (like borders or background colors) or hidden characters in empty cells. To fix this, highlight the empty rows below your data, right-click, select 'Delete', and clear all formatting before saving and printing again.
