How to select row and column by keyboard
Excel
365
Ctrl+Spacebar Selects the entire column
Shift+Spacebar Selects the entire row
Ctrl+Shift+Spacebar or Ctrl+A Selects the entire worksheet (or cells with data)
If you have any questions or suggestions, please feel free to ask OfficeToolTips team.
See Also
Insert current date and time quickly
If you need to date-stamp or time-stamp your worksheet, Excel provides two shortcut keys that do this for
you:
How to change number format easily
A simply way to apply number formatting is to use shortcut keys.
This tip summarizes the shortcut-key combinations that you can use to apply common number formatting to the selected cells or range.
This tip summarizes the shortcut-key combinations that you can use to apply common number formatting to the selected cells or range.
Referencing cells outside the worksheet
Formulas can refer to cells in other worksheets-and the worksheets don't even have to be in the same
workbook. Excel uses a special type of notation to handle these types of references.