Shortcut Keys
Shortcut Keys | Description |
---|---|
F2 | Edit the selected cell. |
F5 | Go to a specific e.g., C6 |
F7 | Spell chech selected text and/or document. |
F11 | Create chart. |
Ctrl + Shift + ; | Enter the current time. |
Ctrl + ; | Enter the current date. |
Alt + Shift + F1 | Insert new worksheet. |
Shift + F3 | Open the Excel formula window. |
Shift + F5 | Bring up search box. |
Ctrl + A | Select all contents of the worksheet. |
Ctrl + B | Bold highlighted selection. |
Ctrl + I | Italic highlighted selection. |
Ctrl + K | Insert link. |
Ctrl + U | Underline highlighted selection. |
Ctrl + 5 | Strike through highlighted selection. |
Ctrl + P | Bring up the print dialog box to begin printing. |
Ctrl + Z | Undo last action. |
Ctrl + F9 | Minimise current workbook. |
Ctrl + F10 | Maximise currently selected workbook. |
Ctrl + F6 | Switch between open workbooks/windows. |
Ctrl + Page up | Move between Excwl worksheets in the same Excel document. |
Ctrl + Page down | Move between Excwl worksheets in the same Excel document. |
Ctrl + Tab | Move between two or more open Excel files. |
Alt + = | Create a formula to sum all of the above cells. |
Ctrl + ' | Insert the value of the above cell into cell currently selected. |
Ctrl + Shift + ! | Format number in comma format. |
Ctrl + Shift + $ | Format number in currency format. |
Ctrl + Shift + # | Format number in date format. |
Ctrl + Shift + % | Format number in percentage format. |
Ctrl + Shift + @ | Format number in time format. |
Ctrl + Arrow key | Move to next section of text. |
Ctrl + Space | Select entire column. |
Shift + Space | Select entire row. |
Nice video..very helpful...please upload more videos
ReplyDeleteNice video..very helpful...please upload more videos
ReplyDelete