Shortcut Keys

Shortcut KeysDescription
F2Edit the selected cell.
F5Go to a specific e.g., C6
F7Spell chech selected text and/or document.
F11Create chart.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Alt + Shift + F1Insert new worksheet.
Shift + F3Open the Excel formula window.
Shift + F5Bring up search box.
Ctrl + ASelect all contents of the worksheet.
Ctrl + BBold highlighted selection.
Ctrl + IItalic highlighted selection.
Ctrl + KInsert link.
Ctrl + UUnderline highlighted selection.
Ctrl + 5Strike through highlighted selection.
Ctrl + PBring up the print dialog box to begin printing.
Ctrl + ZUndo last action.
Ctrl + F9Minimise current workbook.
Ctrl + F10Maximise currently selected workbook.
Ctrl + F6Switch between open workbooks/windows.
Ctrl + Page upMove between Excwl worksheets in the same Excel document.
Ctrl + Page downMove between Excwl worksheets in the same Excel document.
Ctrl + TabMove 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 keyMove to next section of text.
Ctrl + SpaceSelect entire column.
Shift + SpaceSelect entire row.

Comments

  1. Nice video..very helpful...please upload more videos

    ReplyDelete
  2. Nice video..very helpful...please upload more videos

    ReplyDelete

Post a Comment

Popular posts from this blog

Gokaldas Exports reports 152% jump in revenues

US largest source of FDI in FY23; Mauritius, UK next