![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |