Stop Excel from Printing Empty Cells with Borders
Question details
Limit an Excel inventory worksheet to printing columns A through G and the active data rows.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to print the inventory range without extra blank cells that have borders.
- Observed behavior
- Excel prints empty bordered cells beyond the intended inventory range.
Identify the last row containing inventory data and confirm that columns A through G contain everything you want to print. For example, if the last data row is 36, the intended range is A1:G36.
Clear and reset the Excel print area
Use this method to replace an incorrect print area with the exact inventory range.
Open the inventory worksheet and select Page Layout > Print Area > Clear Print Area.
Select columns A through G from the first row to the last active data row, such as A1:G36.
Select Page Layout > Print Area > Set Print Area to restrict printing to the selected cells.
Open File > Print and review the preview to confirm that the unwanted bordered cells are excluded.
Set an inventory print area in WPS Spreadsheet
Open your inventory workbook in WPS Spreadsheet and set a print area that includes only the columns and rows you need.
- 1. Open the workbook: Open WPS Spreadsheet and choose File > Open to select your Excel inventory file.
- 2. Select the inventory range: On the inventory worksheet, select columns A through G through the last row of data, such as A1:G36.
- 3. Set the print area: Choose Page Layout > Print Area > Set Print Area for the selected cells.
- 4. Preview and print: Open File > Print and check the preview before printing.

Frequently Asked Questions
Why does Excel print blank cells with borders?
The current print area may include those cells. Check the preview under File > Print, then use Page Layout > Print Area to clear and reset the range.
How do I print only columns A through G?
Select the cells in columns A through G down to the last row you need, then choose Page Layout > Print Area > Set Print Area.
Will new inventory rows be included automatically?
A fixed print area may not include rows added outside its range. Select the expanded range and use Page Layout > Print Area > Set Print Area again.
Does clearing the print area remove cell borders?
No. Page Layout > Print Area > Clear Print Area removes the print-range setting, not the worksheet's cell formatting.




