Basic shortcuts in excel

To repeat the last action F4
To calculate the worksheet in all open workbook Ctrl+Alt+F9
To rechecks dependent formula Ctrl+Alt+Shift+F9
To define the name Ctrl+F3
To create the names in row and column Ctrl+Shift+F3
Sum Function Alt+=
To display formula Ctrl+`
To insert the argument names into formula Ctrl+Shift+A
To copy formula from cell above Ctrl+’
To paste name into formula F3
To evaluate the part of formula F9
To paste function into formula Shift+F3
To go to last position Ctrl+Shift+F2
To step out Ctrl+Shift+F8
To clear all breakpoints Ctrl+Shift+F9
To Enter the Formula as an Array formula Ctrl+Shift+Enter
Toggle Expand or Collapse formula bar Ctrl+Shift+U
To display Auto complete list Alt+Down arrow
To toggle outline symbols Ctrl+8
To activate menubar Alt or F10
To add the hyperlink Ctrl+K
To undo the last action Ctrl+Z
To create the Chart F11
Hold down shift for additional functions Shift
To find next Shift+F4
Find the value Shift+F5
To insert chart Alt+F1
To open Excel help F1
To open ‘Go To’ dialog box F5
To open spell checker dialog box F7
To activate menubar F10
To view object Shift+F7
To add selection Shift+F8
Quick watch Shift+F9
To Show right click menu Shift+F10
To close the window Ctrl+F4
To activate menubar Ctrl+F10
To close VBA Alt+F4
To switch between last 2 windows Alt+F6
To open VBE  Alt+F11
Go to system menu Alt+Spacebar
To undo the last action Alt+BackSpace
To Export module Ctrl+E
Display ‘Go to Dialog” box Ctrl+G
Replace the value Ctrl+H
List Properties/Methods Ctrl+J
Show Call Stack Ctrl+L
Go to cycle windows Ctrl+Tab
To Edit Parameter Info Ctrl+Shift+I
To Edit List Constants Ctrl+Shift+J
To display or hide the ribbons Ctrl+F1
To Group Rows or Columns Alt+Shift+Right Arrow
Ungroup Rows or Columns Alt+Shift+Right Arrow
To Add/Remove the filter Ctrl+Shift+L
To Adjust Column Width to Fit the Content Alt+O+C+A
To Adjust Column Width to Specific Value Alt+O+C+W
To Adjust Row Height to Fit the Content Alt+O+R+A
To Adjust Row Height to Specific Value Alt+O+R+E
To Open Pivot Table wizard Alt+D+P
Align Left Alt+H, AL
Align Right Alt+H, AR
Align Cight Alt+H- AC
Align Top Alt+H, AT
Align Middle Alt+H, AM
Align Bottom Alt+H- AB
To wrap the text Alt+H, W
Highlight Cell (change cell backgroudn color) Alt+H, H
Font Color Alt+H, FC
Font Size Alt+H, FS
Merge Cells – Merge Alt+H, MM
Merge Cells – Unmerge Alt+H, MU
Merge Cells – Merge and Center Alt+H, MC
Merge Cells – Merge Across Alt+H, MA
To merge the text Alt+H, M
To change the font style Alt+H, FF
To change the font size Alt+H, FS
Fomat painter Alt+H, FP
To record macro Alt+Y, R
To Open dialog box of Name Manager Al+M, N
To open Data Validation dialog box Alt+A,VV
To insert the Pivot Table Alt+N,V
To insert the Table Alt+N,T
To insert Column chart Alt+N, C
To insert Bar chart Alt+N, B
To insert Stock, Surface and Radar chart Alt+N, O
To insert Line Chart Alt+N, N
To insert Area Chart  Alt+N, A11
To insert Combo Chart Alt+N, SD
To insert Pie Chart Alt+N, Q
To insert Scatter Chart Alt+N, D
To open new worksheet Alt+F, N
To open the file Alt+F, O
To save the file Alt+F, S
To Save as the file Alt+F, A
To share the file Alt+F, H
To export the file Alt+F, E
To close the file Alt+F, C
To check the account Alt+F, D
To open the Excel options Alt+F, T

Priyansh Minocha

Priyansh Minocha is C.E.O and Director at Amonest India Private Limited and Founder at Casolutionsglobal

Leave a Reply