Navigation Shortcuts
Movement in Cells
|
Arrow
Keys
|
Navigation Shortcuts
Move to Beginning of Worksheet
|
Ctrl + Home
|
Navigation Shortcuts
Switches between Worksheet Tabs(Right to Left)
|
Ctrl + PgDn
|
Navigation Shortcuts
Switches between Worksheet from Left to Right
|
Ctrl +{PgUp
|
Navigation Shortcuts
Go to Next Tab
|
Ctrl + Tab
|
Navigation Shortcuts
Go to Previous Tab
|
Ctrl + Shift + Tab
|
Navigation Shortcuts
Moves One Cell down in Selected Cell Range
|
Enter
|
Navigation Shortcuts
Moves One Cell Up in Selected Cell Range
|
Shift + Enter
|
Navigation Shortcuts
Moves to Cell in Upper Left Corner of Window
|
Home
|
Navigation Shortcuts
Select Cell in Next Screen in Same Column
|
PgDn
|
Navigation Shortcuts
Select Cell in Previous Screen in Same Column
|
PgUp
|
Navigation Shortcuts
Move one cell to Right
|
Tab
|
Navigation Shortcuts
Move one cell to Left
|
Shift + Tab
|
Navigation Shortcuts
|
|
Selection Shortcuts
Select All Worksheet
|
Ctrl + Arrow
Keys
|
Selection Shortcuts
Select Cell Range from Current Cells to Next Screen of Same Column
|
Shift + PgDn
|
Selection Shortcuts
Select Cell Range from Current Cells to Previous Screen of Same Column
|
Shift + PgUp
|
Display Various Objects
Display MS Visual Basic Editor
|
Alt + F11
|
Display Various Objects
Display Spelling Check Dialog Box
|
F7
|
Display Various Objects
Display Macros Dialog Box to Run,Edit or Delete Macros
|
Alt + F8
|
Display Various Objects
Display Control Menu from Program Window
|
Alt + Space
|
Display Various Objects
Display Format Cells Dialog Box
|
Ctrl + 1
|
Display Various Objects
Display Task Pane on Right Side of Program Window
|
Ctrl + F1
|
Display Various Objects
Display Go to Dialog Box
|
Ctrl + G
|
Display Various Objects
Display Replace Dialog Box
|
Ctrl + H
|
Display Various Objects
Go to Find Dialog Box
|
Ctrl + F
|
Display Various Objects
Display Print Dialog Box
|
Ctrl + P
|
Display Various Objects
Display Insert Dialog Box
|
Ctrl + Shift + =
|
Display Various Objects
Display Context Menu of Selected Item
|
Shift + F10
|
Display Various Objects
Display Open Dialog Box
|
Ctrl + O
|
Other Shortcuts
Starts New Line in Same Cell
|
Alt + Enter
|
Other Shortcuts
Clears the content of the active cell to reedit cell content
|
Backspace
|
Other Shortcuts
Enters the current time
|
Ctrl + '
|
Other Shortcuts
Enters the current date
|
Ctrl + ;
|
Other Shortcuts
Applies or removes bold formatting
|
Ctrl + B
|
Other Shortcuts
Copies the selected cells
|
Ctrl + C
|
Other Shortcuts
Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
|
Ctrl + D
|
Other Shortcuts
Moves to the last cell on a worksheet, in the lowest used row of the rightmost used column
|
Ctrl + End
|
Other Shortcuts
Fills the selected cell range with the current entry
|
Ctrl + Enter
|
Other Shortcuts
Applies or removes italic formatting
|
Ctrl + I
|
Other Shortcuts
Create New workbook
|
Ctrl + N
|
Other Shortcuts
Displays the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks
|
Ctrl + K
|
Other Shortcuts
Saves the active file with its current file name, location, and file format
|
Ctrl + S
|
Other Shortcuts
Enters the current time
|
Ctrl + Shift + '
|
Other Shortcuts
Enters the current time
|
Ctrl + Shift + ;
|
Other Shortcuts
Applies or removes underlining
|
Ctrl + U
|
Other Shortcuts
Paste
|
Ctrl + V
|
Other Shortcuts
Closes the selected workbook window
|
Ctrl + W
|
Other Shortcuts
Cuts the selected cells
|
Ctrl + X
|
Other Shortcuts
Repeats the last command or action, if possible
|
Ctrl + Y
|
Other Shortcuts
Undo
|
Ctrl + Z
|
Other Shortcuts
Help
|
F1
|
Other Shortcuts
Insert chart
|
F11
|
Other Shortcuts
Displays the Save As dialog box to save the file with a different name, type or location
|
F12
|
Other Shortcuts
Edits the active cell and positions the insertion point at the end of the cell contents
|
F2
|
Other Shortcuts
Repeats the last action of adding or deleting the Whole Row/Column
|
F4
|