Place your pointer on any cell of the required column and type Ctrl + Space.

Shortcuts for Data SelectionĬtrl + A – Selects the whole text of your workbookĬtrl + Space – Selects the whole column. Similarly, Ctrl+ Pgdn takes to the previous sheet of your current page. Ctrl + PgUp takes you to the next sheet of your current page.

The selected cells will become a table Shortcut for FormulasĬtrl + `- Lets you toggle between formulas and cell valuesĬtrl + ‘-Applies the formula of a selected cell to another cellį4 –Will show you the reference value of a cell Navigational ShortcutsĬtrl + Tab –Allows you to move between different workbooksĬtrl + End –Moves you to the last cell of your current workbookĬtrl + Home- Moves you to the first cell of your active workbookĬtrl + PgUp and Ctrl + PgDn – These shortcut keys help you navigate between different pages of a workbook.

A cell is the smallest unit of area in an Excel spreadsheetĬtrl + V –Copies the content of the selected cells on to the clipboardĬtrl + P –Opens the print dialogue box Text Formatting ShortcutsĬtrl + 1 –Opens the format dialogue box for the cells of your workbookĬtrl + T –Chose your cells and press Ctrl + T. Ctrl + X – Cuts the content of the highlighted area in your workbook (cells).

M.s excel shortcut keys