These short cut keys should help you use Excel in a more efficient manner, making your work easier and help cut time off your Excel workload.Also see: Excel shortcuts on the Mac // 3 minute video 1. Shortcut for Data EnteringĪlt + Enter – You can enter a new line in a cell while editing itĬtrl + D –You can copy the format of the cells and apply this formatting to a selected range of cells.Ĭtrl + –Insert the current date and time in your selected cell

Place your pointer on your required row and type Shift + Space.

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).

Formula pdf excel shortcut keys