Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% 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. 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:Ģ. Then you can see the selection is extended to the entire row with data as below screenshot show.ġ. 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 end of current column as below screenshot shown.Ģ. Select the first or any cell of the column or row, and then press the keys simultaneously. The following shortcut keys help you extending selection to end of column or row in Excel.ġ.
#Shortcut excel for selecting current row excel mac how to
In this article, we will show you how to extend the selection to the end of column or row after selecting the first cell.Įxtend selection to the end of column of row with shortcut key When working with a long column or row, you may need to select the whole column or row with data for some purpose. How to extend selection to the end of column or entire row in Excel?
0 kommentar(er)
