How to quickly move to the end of column or row in Excel?
If there is a long list in a sheet, and you want to move to the last data of this list, you need to scroll manually until the end of this list which is annoying for you. Here I introduce some tricks to quickly move to the end of column or row in Excel.
Move to the end of column or row in active range with shortcuts
Move to the last column or row in used range with Kutools for Excel
Comparison of Methods for Moving to the End of a Row or Column in Excel
When working with a long or wide dataset, you can use Excel keyboard shortcuts to quickly navigate through a continuous data range, or use Kutools for Excel to jump directly to the last cell, row, or column in the used range.
| Comparison | Excel Shortcuts | Kutools Select Last Cell |
|---|---|---|
| Navigation target | End of the current continuous data range | Last cell, last row, or last column in the used range |
| Available options | Ctrl + ↓ for columns; Ctrl + → for rows | Last Cell, Last Row, and Last Column |
| When blank cells exist | Stops at the last data cell before the first blank row or column | Jumps to the end of the worksheet's used range |
| Best for | Quick navigation through continuous datasets | Finding the actual end of large or irregular datasets with gaps |
Move to the end of column or row in active range with shortcuts
Click at any one data of the column you want to move to the end, and hold Ctrl key and press 
key to quickly move to the end of the column in the data range.
If you want to move to the end of row in the active data range, hold Ctrl key and press 
.
Tip: If there is blank row or column between the data, it only moves to the last data above the first blank row or column. See screenshot:
Move to the last column or row in used range with Kutools for Excel
In some cases, you want to move to the last column, row or cell in used range instead of last data, with Kutools for Excel’s Select Last Cell utility can help you.
After free downloading and installing Kutools for Excel, please do as below:
Enable the sheet you want to locate in the last column or row in the used range, click Kutools > Select > Select Last Cell > Select Last Cell/Last Row/Last Column. See screenshot:
| Select Last Cell | Last Row | Last Column |
 |  |  |
Conclusion
Excel shortcuts are the fastest built-in option when your data is continuous. Ctrl + ↓ moves to the end of the current column data range, while Ctrl + → moves to the end of the current row data range. However, if blank rows or columns exist within the data, the shortcut stops before the first blank.
Kutools for Excel's Select Last Cell is more convenient when you need to locate the end of the entire used range. It provides dedicated options for Last Cell, Last Row, and Last Column, making it especially useful for large or irregular worksheets where gaps in the data can interrupt Excel's standard navigation shortcuts.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in