Printing Problems

Stop Excel from Printing Empty Cells with Borders

Anum MushtaqAnum Mushtaq Nov 22, 2026 868 views

Question details

Limit an Excel inventory worksheet to printing columns A through G and the active data rows.

Stop Excel from Printing Empty Cells with Borders
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.
Before you start

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.

Solution 1Recommended

Clear and reset the Excel print area

Use this method to replace an incorrect print area with the exact inventory range.

1
Clear the existing print area

Open the inventory worksheet and select Page Layout > Print Area > Clear Print Area.

2
Select the inventory cells

Select columns A through G from the first row to the last active data row, such as A1:G36.

3
Set the new print area

Select Page Layout > Print Area > Set Print Area to restrict printing to the selected cells.

4
Check the preview

Open File > Print and review the preview to confirm that the unwanted bordered cells are excluded.

Update the range when data changes: If inventory rows or columns are added or removed, select the updated range and set the print area again.
Print only the inventory range

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. 1. Open the workbook: Open WPS Spreadsheet and choose File > Open to select your Excel inventory file.
  2. 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. 3. Set the print area: Choose Page Layout > Print Area > Set Print Area for the selected cells.
  4. 4. Preview and print: Open File > Print and check the preview before printing.
Exclude empty bordered cells outside the selected print areaOpen and edit Microsoft Excel XLS and XLSX filesPreview the selected worksheet range before printingUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.