In this tutorial, you will learn how to delete a page in google sheets.
By default, Google Sheets have 1000 rows, although you can easily add or remove rows to change this number. Most people, however, don’t bother removing unused rows from the end of the spreadsheet as they may be needed to add additional data. This is typically not an issue, but under certain circumstances these unused rows at the end of the spreadsheet end up printing as blank pages when you go to print the spreadsheet, often for no apparent reason
If you’re running into this issue, don’t worry, this tutorial will go through the most common reasons this happens and how to fix them
Understanding the Problem
The first step to fixing this problem is to understand why Google Sheets is printing blank pages. This is almost always because Google Sheets doesn’t perceive the rows as being truly empty, due to them having some sort of cell formatting applied to them. The formatting could be something obvious like a fill color applied to an entire column, or it might be something incredibly difficult to notice, like white gridlines on all the cells in a column. The formatting may also only be applied to certain rows far down the sheet, making it harder to locate.
Note that text formatting such as text color, size, etc will not cause this issue
Now that you understand why these blank rows are printing, it’s time to clear the formatting from the blank rows so they don’t print. If you know the exact issue, you can target it directly. For example, if row 300 is highlighted yellow, you could simply reset the fill color for that row. If you don’t know what formatting is causing the issue, or you just want to clear all cell formatting from the range, here’s how:
Scroll down to the last row of data in the sheet and select the first blank row by clicking on the row number beside it
Hold down CTRL + SHIFT on your keyboard then press the down arrow to select all the rows down to the bottom of the sheet. The selected range now includes all the blank rows that should not print
Remove any fill color from the selection by clicking on the Fill Color icon in the toolbar and choosing Reset
Remove any borders from the selection by clicking on the Borders icon in the toolbar and choosing the Clear Borders option
Clearing these two cell format options should do the trick. Try printing the spreadsheet again and the blank pages should be gone
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to delete a page in google sheets. Want more? Check out all the Google Sheets Tutorials.