How to Quickly Select the Last Cell

Please follow the steps below to quickly select the last cell in the worksheet, which is very convenient when you work with a large file:

Step 1: Click anywhere in the worksheet;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Find & Select" in the Editing section, and select "Go To Special" from the list;

Step 3: Check "Last Cell" in the "Go To Special" window;

Step 4: Click "OK" at the bottom, the last cell with data in the worksheet will be selected.

Leave a Reply