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.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
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:
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 120 handy Excel functions, enhance your working efficiency and save your working time.|
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|