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 |