How to move or go to last row/last column with data in Excel?
In some cases, you may need to move and locate to the last row or last column with data in Excel. In this article, we will show you methods of moving to the last cell in used range with shortcut, as well as directly moving to last row or column with data by just one click.
Excel Productivity Tools
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 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
With the shortcut keys Ctrl + End, you can move to the last cell of used range in your worksheet.
Note: The last cell of used range could be a blank cell.
If you want to directly move to the last row or last column with data in Excel, please browse the next method.
With the Select Last Row and Select Last Column utilities of Kutools for Excel, you can easily select the last row or column with data by just one click in Excel.
|Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 60 days.|
Move to last row with data
After installing Kutools for Excel, click Kutools > Select > Select Last Cell > Last Row. See screenshot:
Move to last column with data
For moving to the last column with data in current worksheet, click Kutools > Select > Select Last Cell > Last Column. See screenshot:
Then you can see the last row or last column with data in current worksheet is selected immediately.