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
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.
Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. | ||
After free 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 |
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!