If multiple cells are selected, select only the active cell Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)Įxtend the selection to the last nonblank cell in the same column or row as the active cellĮxtend the selection to the beginning of the rowĮxtend the selection to the beginning of the worksheetĮxtend the selection to the last cell used on the worksheet (lower-right corner) Select cells, columns, rows, or objects in worksheets and workbooks by using shortcut keys :- CTRL+SHIFT+* (ASTERISK)
Here Are Very Useful Shortcut Keys Of Microsoft Excel, That Will Help You To Speed Up Your Work And Short The Time Consumption Of Work, So Check Out Below:.