This tutorial demonstrates how to reset the last cell in Excel and Google Sheets.
Locate Last Cell
Sometimes, your workbook contains empty cells with formatting between the last cell of the workbook and the data. This makes the file size larger than necessary. To avoid this problem, locate the last cell that contains data or formatting, and delete all empty cells between the last cell and the data. To locate the last cell that contains the data or formatting, click anywhere on the sheet and just press CTRL + END, which selects the last cell.
The first thing you should do is to locate the last cell and see if there are any empty cells that contain formatting between the last cell and the data. If there are, follow these steps to delete them:
1. To select all of the columns between the last one that contains data and the one that contains the last cell select the column header in the first empty column and press CTRL + SHIFT + END.
As a result, all of the columns in between are selected.
2. To select all the rows between the last one that contains data and the one that contains the last cell select the column header in the first empty row and press CTRL + SHIFT + END.
As a result, all the rows between these two are selected.
3. Now, you have all the empty cells with formatting between the data and the last cell selected. To clear them, in the Ribbon go to Home > Clear > Clear All.
4. After this, save the file and close the workbook.
When you open your file again, the last cell should be the last cell of the data.
Go to the Last Cell in Google Sheets
In Google Sheets, when you delete cells, formatting is also deleted so there won’t be empty cells between the data and the last cell. If you were to use the CTRL + END shortcut, it will always navigate to the last cell of the sheet (Z1000).