See all How-To Articles

How to Reset the Last Cell in Excel & Google Sheets

This tutorial demonstrates how to reset the last cell in Excel and Google Sheets.

 

reset last cell 1

 

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.

 

reset last cell 9

 

Delete Formatting

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.

 

reset last cell 2

 

As a result, all of the columns in between are selected.

 

reset last cell 3

 

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.

 

reset last cell 4

 

As a result, all the rows between these two are selected.

 

reset last cell 5

 

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.

 

reset last cell 6

 

4. After this, save the file and close the workbook.

 

reset last cell 7

 

When you open your file again, the last cell should be the last cell of the data.

 

reset last cell 8

 

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).