Keyboard Shortcuts for Excel Day 1

SNShortcutsDescriptions
1Windows Key + RRun
2F1Help
3Ctrl + F1Hide / Unhide Ribbon
4Crtl + ASelect the current Region or Select All
5Ctrl + NNew Workbook
6Shift + F11Insert New Sheet
7Alt + E + LDelete Active Sheet
8Ctrl + Spece BarSelect Entire Column
9Shift + Spece BarSelect Entire Row
10Ctrl + Shift + Spece BarSelect Entire Sheet or Region
11Left AeroMove the active cell to the Down
12Right AeroMove the active cell to Right
13Down AeroMove the active cell to Down
14Up AeroMove the active cell to the Right
15Enter KeyMove the active cell to the Down
16Shift + Enter KeyMove the active cell to the up
17Tab keyMove the active cell to the Right
18Shift + Tab KeyMove the active cell to the left
19F2Edit active cell
20Ctrl + WClose the workbook
21Ctrl + OOpen
22Ctrl + SSave
23F12Save As
24Ctrl + CCopy
25Ctrl + XCut
26Ctrl + VPaste
27Ctrl + ZUndo
28Ctrl + YRedo
29Ctrl + BBold the Selection
30Ctrl + 0Hide the Column
31Ctrl + Shift + )Unhide the Column
32Ctrl + 9Hide the row
33Ctrl + Shift + (Unhide the Row
34Ctrl + Aero KeyMove to the edge of the current data region in a worksheet.
35Home KeyBeginning of the Row
36Ctrl + HomeMove to the beginning of a worksheet.
37Page UpMove one screen Up in a worksheet.
38Page DownMove one screen down in a worksheet.
39Alt + Page UpMove one screen to the left in a worksheet.
40Alt + Page DownMove one screen to the Right in a worksheet.
41Ctrl + Page UpMove to the previous sheet in a workbook.
42Ctrl + Page DownMove to the next sheet in a workbook.
43EscExit the floating shape navigation and return to the normal navigation

Comments are closed.