How to extend selection to the end of column or entire row in Excel?
When working with a long column or row, you may need to select the whole column or row with data for some purpose. In this article, we will show you how to extend the selection to the end of column or row after selecting the first cell.
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
The following shortcut keys help you extending selection to end of column or row in Excel.
1. Select the first or any cell of the column or row, and then press the keys simultaneously. Then you can see the selection is extended to the end of current column as below screenshot shown.
2. For extending the selection to the entire row, please select the first or any cell of the row, then press keys simultaneously.
Then you can see the selection is extended to the entire row with data as below screenshot show.
1. If the first selected cell is empty, it will extend the selection to the first non-empty cell below the selected cell as following screenshot shown:
2. If there are blank cells exist in the column, the selection will stop at the first blank cell after using the shortcut key as below screenshot shown.