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.