Method #2: Remove blank rows between data
Another problem that might cause Excel to print extra blank pages is extra rows between your data.
In the image here, we again have data spread across four columns (Columns A to D) and 8 rows (Rows 1 to 8).
And apparently, we don’t see anything else on the sheet. It seems clean.
But the print preview shows there are 3 active pages😏
Scrolling through the print preview, this time a row far away in the sheet has some data to it.
To check if the sheet you’re printing has some extra data on the sides:
- Go to the last row/column of the data. Row 8 in our case is the last row that contains data.
- Press the Control key + the down arrow (or the right arrow in case of columns).
- Excel will navigate you to the next row of the sheet that has data.
This shows that Row 104 also has some data.
And there are plenty of rows between Rows 8 and 104 that are causing these blank pages❌
To remove the blank rows in between:
- Go to the first blank row (Row 9 in our case).
- Press the Control Key + the Shift Key + the down arrow.
Doing so will select all the rows until the next row that has data (Row 104).
- As we do not want to delete Row 104 itself (it contains data), press down the Shift Key + and press the upward arrow.
This will unselect one row down (Row 104)💡
Now we have all blank rows from Row 9 to Row 103 selected.
- Go to the Home tab > Delete > Delete rows.
Alternatively, press the Control key and the – key to delete the selected rows.
Now there are no more blank rows in our data, so let’s go and see how the print preview changes🧹
Yay! No more blank pages. We have the relevant data table on page 1 only.