Knowledge Hub
Excel Shortcut Keys
✺ Working With Files
Function Shortcut Keys
New le Ctrl + N
Open Ctrl + O
Save Ctrl + S
Save as Ctrl + Shift + S
Print Ctrl + P
Print preview Ctrl + F2
Close workbook Ctrl + W
Close Excel Ctrl + Q
✺ Working With Data
Function Shortcut Keys
Copy Ctrl + C
Cut Ctrl + X
Paste Ctrl + V
Paste special Ctrl + Alt + V
Undo Ctrl + Z
Redo Ctrl + Y
Find Ctrl + F
Find previous Ctrl + Shift + F4
Find next Shift + F4
Find and replace Ctrl + H
✺ Moving Within A Workbook
Function Shortcut Keys
Move right 🡆
Move left 🡄
Move up 🡅
Move down 🡇
Move right to next full cell Ctrl + 🡆
Move left to next full cell Ctrl + 🡄
Move up to next full cell Ctrl + 🡅
Move down to next full cell Ctrl + 🡇
Move to beginning of row Home
Move to last cell Ctrl + End
Move to rst cell Ctrl + Home
Scroll right one screen Alt + PgDn
Scroll left one screen Alt + PgUp
Scroll up one screen PgUp
Scroll down one screen PgDn
End mode End
✺ Selecting Cells
Function Shortcut Keys
Go to cell Ctrl + G
Select all Ctrl + A
Select row Shift + Space
Select column Ctrl + Space
Select current region Ctrl + Shift + *
Select current array Ctrl + /
Select all precedents Ctrl + Shift + {
Select direct dependents Ctrl + ]
Select all dependents Ctrl + Shift + }
Select only visible cells Alt + ;
Add cell range to selection Shift + Click
Add one-o cells to selection Ctrl + Click
Move active cell right to non-adjacent selection Ctrl + Alt + 🡆
Move active cell left to non-adjacent selection Ctrl + Alt + 🡄
Toggle selection add mode Shift + F8
Clear selection Esc
Expand selection to the right Shift + 🡆
Expand selection to the left Shift + 🡄
Expand selection up Shift + 🡅
Expand selection down Shift + 🡇
Expand selection to last full cell to the right Ctrl + Shift + 🡆
Expand selection to last full cell to the left Ctrl + Shift + 🡄
Expand selection to last full cell up Ctrl + Shift + 🡅
Expand selection to last full cell down Ctrl + Shift + 🡇
Expand selection up full screen Shift + PgUp
Expand selection down full screen Shift + PgDn
Expand selection to beginning of row Shift + Home
Expand selection to rst worksheet cell Ctrl + Shift + Home
Expand selection to last worksheet cell Ctrl + Shift + End
Toggle extend selection mode F8
Select only cells with comments Ctrl + Shift + O
Select row di erences Ctrl + \
Select column di erences Ctrl + Shift + |
Select direct precedents Ctrl + [
✺ Working With Active Cells
Function Shortcut Keys
Only select active cell Shift + Backspace
Show active cell Ctrl + Backspace
Move active cell clockwise Ctrl + .
Move active cell down Enter
Move active cell up Shift + Enter
Move active cell right Tab
Move active cell left Shift + Tab
✺ Editing Formulas
Function Shortcut Keys
Edit active cell F2
Cancel entry Esc
Delete to end of line Ctrl + Delete
Delete character in back of cursor Backspace
Delete character in front of cursor Delete
New line within cell Alt + Enter
Add character to the right to selection Shift + 🡆
Add character to the left to selection Shift + 🡄
Move one word right Ctrl + 🡆
Move one word left Ctrl + 🡄
Add word to right to selection Ctrl + Shift + 🡆
Add word to left to selection Ctrl + Shift + 🡄
Select from beginning of cell to current position Shift + Home
Select from current position to end of cell Shift + End
Insert comment Shift + F2
✺ Entering Data
Function Shortcut Keys
Commit and move down Enter
Commit and move up Shift + Enter
Commit and move right Tab
Commit and move left Shift + Tab
Commit and stay in same cell Ctrl + Enter
Enter data in multiple cells Ctrl + Enter
Insert current date Ctrl + ;
Insert current time Ctrl + Shift + :
Fill from cell above Ctrl + D
Fill from cell to left Ctrl + R
Fill formula from cell above Ctrl + '
Hyperlink Ctrl + K
Display Autocomplete Alt + 🡇
✺ Using The Ribbon
Function Shortcut Keys
Show / hide Ribbon Ctrl + F1
Enter Windows hotkey combination Alt
Help F1
✺ Formatting Cells
Function Shortcut Keys
Open format dialogue Ctrl + 1
Re-apply format F4
Align center Alt + H + A + C
Align left Alt + H + A + L
Align right Alt + H + A + R
Indent Alt + H + 6
Un-indent Alt + H + 5
Increase font size Alt + H + FG
Decrease font size Alt + H + FK
Format as general Ctrl + Shift + ~
Format as currency Ctrl + Shift + $
Format as percentage Ctrl + Shift + %
Format as scienti c Ctrl + Shift + ^
Format as date Ctrl + Shift + #
Format as time Ctrl + Shift + @
Format as number Ctrl + Shift + !
Bold Ctrl + B
Italic Ctrl + I
Underline Ctrl + U
Strikethrough Ctrl + 5
Border all Ctrl + Shift + &
Border right Alt + R
Border left Alt + L
Border top Alt + T
Border bottom Alt + B
Border interior horizontal Alt + H
Border interior vertical Alt + V
Remove borders Ctrl + Shift + _
✺ Calculations
Function Shortcut Keys
Toggle reference (relative vs. absolute) F4
Calculate all sheets F9
Calculate only active sheet Shift + F9
Autosum Alt + =
Insert function Shift + F3
Show function arguments Ctrl + Shift + A
Commit array formula Ctrl + Shift + Enter
Evaluate part of formula F9
Toggle formula bar Ctrl + Shift + U
Show formula builder Ctrl + A
De ne name Ctrl + F3
Create name Ctrl + Shift + F3
Paste name into formula F3
✺ Worksheets And Workbooks
Function Shortcut Keys
New worksheet Shift + F11
Next worksheet Ctrl + PgDn
Previous worksheet Ctrl + PgUp
Next workbook Ctrl + Tab
Previous workbook Ctrl + Shift + Tab
Next pane F6
Previous pane Shift + F6
Minimize window Ctrl + F9
Maximize window Ctrl + F1
Select multiple worksheets Shift + Click
Select one-o single worksheets Ctrl + Click
✺ Rows And Columns
Function Shortcut Keys
Insert rows / columns dialogue Ctrl + Shift + +
Insert rows Ctrl + Shift + +
Insert columns Ctrl + Shift + +
Delete dialog Ctrl + -
Delete rows Ctrl + -
Delete columns Ctrl + -
Delete cells Ctrl + -
Clear cells Delete
Group Alt + Shift + 🡆
Ungroup Alt + Shift + 🡄
Group dialog Alt + Shift + 🡆
Ungroup dialog Alt + Shift + 🡄
Hide columns Ctrl +
Hide rows Ctrl + 9
Unhide rows Ctrl + Shift + 9
Unhide columns Ctrl + Shift +
Toggle outline symbols Ctrl + 8
✺ Charts, Filters, And Pivots
Function Shortcut Keys
Create chart Alt + F1
Create chart (new sheet) F11
Auto lter Ctrl + Shift + L
Open lters Alt + 🡇
Insert table Ctrl + T
Group pivot table items Alt + Shift + 🡆
Ungroup pivot table items Alt + Shift + 🡄
Hide pivot table item Ctrl + -
Create pivot chart Alt + F1
Create pivot chart on new sheet F11
Pivot table wizard Alt + D + P
✺ Helper Modules
Function Shortcut Keys
Spell check F7
Thesaurus Shift + F7
VBA editor Alt + F11
Macros Alt + F8
Hide or show Ctrl + 6
Duplicate Ctrl + D
Modify cell style Alt + '
Control menu Alt + Space
Shortcut menu Shift + F1
़ वभ
नोट : यह पीडीऍफ ोत से त य एक त कर बनायी गयी है | य द इसम कोई ट
ु ी पायी जाती है तो नॉलेज हब सं चालक क
ज मेदारी नही होगी |
Click Here To Join Telegram Channel
www.knowledgekahub.com
