Here we list out the most useful MS Excel Shortcut Keys supported by Microsoft Excel. That’s why Microsoft office supports a wide range of MS Excel Shortcut Keys to complete our work more fast and comfort. 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.We all know that MS Excel Shortcut Keys are very useful to speed up our work. 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).
0 kommentar(er)
