Most Important Keyboard Shortcuts MS Excel
In this section we update Most Important Keyboard Shortcuts MS Excel under the 13 topics below.
So read each of these keyboard shortcuts of Excel and definitely these all shortcuts will be very useful to you in your daily computer work and also many of questions asked about the shortcuts of computer in many examinations, so learn it all.
Additionally if you want to read computer general knowledge questions answers then you can read this post about computer gk.
These Excel shortcuts will be very helpful in your online examinations if shortcuts allows, even these will also help you in your daily office or home as smart excel work.
The Fundamentals ? | |||
Ctrl + O | Open File | Ctrl + N | New File |
Ctrl + P | Ctrl + S | Save File | |
F12 | Save File As | Ctrl + F4 | Close File |
Alt + F4 | Close Excel | Esc | Exit Dialog |
Ctrl + C | Copy | Ctrl + X | Cut |
Ctrl + V | Paste | Ctrl + Z | Undo |
Ctrl + Y | Redo | Ctrl + A | Select All |
Ctrl + F | Find | Ctrl + H | Replace |
Alt + Tab | Switch Windows | Alt + T + O | Options Menu |
F4 | Repeat Last Action | Ctrl + F1 | Show / Hide Ribbon Menu |
Workbooks & Worksheets ? | |||
Ctrl + N | New Workbook | ||
Ctrl + Tab | Switch Workbook | ||
Shift + F11 | New Worksheet | ||
Alt + H + D + S | Del Worksheet | ||
Ctrl + PgUp | Move to Left Worksheet | ||
Ctrl + PgDn | Move to Right Worksheet | ||
Alt + H + O + M | Move / Copy Worksheet | ||
Shift + Ctrl + PgUp / PgDn | Select Multiple Worksheets | ||
Alt + H + O + U + S | Hide Worksheet | ||
Alt + H + O + U + H | Show Worksheet | ||
Alt + H + O + R | Rename Worksheet | ||
Alt + H + O + T | Color Tab | ||
Rows & Columns ? | |||
Ctrl + Spacebar | Select Column | ||
Shift + Spacebar | Select Row | ||
Ctrl + Shift + + | Insert Cells / Rows / Columns | ||
Ctrl + – | Delete Cells / Rows / Columns | ||
Right Mouse Button + E | Insert Cut Cells and Shift Over | ||
Alt + A + G + G | Group Rows / Columns | ||
Shift + Alt + Right | Group Rows / Columns | ||
Alt + A + U + U | Ungroup Rows / Columns | ||
Shift + Alt + Left | Ungroup Rows / Columns | ||
Alt + A + J | Show Grouped Rows / Columns | ||
Alt + A + H | Hide Grouped Rows / Columns | ||
Basic Formatting ? | |||
Alt + H | Format Menu | ||
Ctrl + 1 | Format Dialog | ||
Ctrl + Alt + V | Paste Special | ||
Ctrl + Alt + V + T | Paste Formats | ||
Ctrl + Alt + V + V | Paste Values | ||
Ctrl + Alt + V + F | Paste Formulas | ||
Alt + H + FC | Font Color | ||
Alt + H + H | Fill Color | ||
Alt + H + B | Border Options | ||
Alt + H + A + L / C / R | Align Left / Center/ Right | ||
Alt + H + 6 | Increase Indent | ||
Alt + H + 5 | Decrease Indent | ||
Alt + H + 0 | Increase Decimal Places | ||
Alt + H + 9 | Decrease Decimal Places | ||
Ctrl + B | Bold | ||
Ctrl + I | Italics | ||
Ctrl + U | Underline | ||
Ctrl + 5 | Strikethrough | ||
Ctrl + Shift + & | Add Borders | ||
Ctrl + Shift + – | Delete Borders | ||
Shift + Ctrl + ~ | General | ||
Shift + Ctrl + ! | Number | ||
Shift + Ctrl + @ | Time | ||
Shift + Ctrl + # | Date | ||
Shift + Ctrl + $ | Currency | ||
Shift + Ctrl + % | Percentage | ||
Shift + Ctrl + ^ | Scientific | ||
Navigation & Data Selection ? | |||
Arrow Keys | Move Around | ||
Ctrl + Arrows | Jump to Boundary | ||
Shift + Arrows | Select Cells | ||
Shift + Ctrl + Arrows | Select to Boundary | ||
Shift + F8 | Select Multiple Areas | ||
Editing Cells ? | |||
F2 | Edit Cell | ||
Del | Delete Cell Contents | ||
Ctrl + Arrows | Skip Word(s) | ||
Ctrl + Shift + Arrows | Highlight Word(s) | ||
Alt + Enter | New Line in Cell | ||
Displays cell using custom format ? | |||
Alt + H + O + I | Auto-Fit Col. | ||
Alt + H + O + A | Auto-Fit Row | ||
Alt + H + O + W | Column Width | ||
Alt + H + O + H | Row Height | ||
Alt + H + L + R | Conditional Formatting | ||
Alt + H + T | Format as Table | ||
Common Built-In Functions ? | |||
=SUM | Sum Numbers | ||
Alt + = | Sum Adjacent Cells | ||
=COUNT | Count # Entries | ||
=AVERAGE | Average | ||
=MAX | Maximum | ||
=MIN | Minimum | ||
=SUMIF / =SUMIFS | Conditional Sum | ||
=COUNTIF / =COUNTIFS | Conditional Count | ||
=SUMPRODUCT | Multiply and Sum Range | ||
=ABS | Absolute Value | ||
=IF | Conditional | ||
=OR | One Must Be True | ||
=AND | All Must Be True | ||
=NPV (Discount Rate, Cash Flows) | Net Present Value of Cash Flows | ||
=XNPV (Rate, Values, Dates) | NPV with irregular dates | ||
=IRR (Values) | Internal Rate of Return of Investment | ||
=XIRR (Values, Dates) | IRR with irregular dates | ||
Auditing Formulas ? | |||
Ctrl + [ | Immediate Precedents | ||
Ctrl + ] | Immediate Dependents | ||
Alt + M + P | Trace Precedents | ||
Alt + M + D | Trace Dependents | ||
Alt + M + A + A | Erase Traces | ||
Shift + Ctrl + { | All Precedents | ||
Shift + Ctrl + } | All Dependents | ||
F5 + Enter | Jump to Original Cell | ||
Shift + F2 | Add/Edit Comment | ||
Alt + R + D | Del Comment | ||
Alt + R + A | Show All Comments | ||
F5, Alt + S + C | Highlight Cells w/ Comments | ||
Macros, VBA, and Forms ? | |||
Alt + F11 | VBA Editor | ||
F5 (in VBA) | Run Macro | ||
F2 (in VBA) | Object Browser | ||
Ctrl + G (in VBA) | Immediate Window | ||
Alt + L + I | Form Control | ||
Alt + W + M + U | Use Relative References | ||
Alt + W + M + R | Record Macro | ||
Alt + W + M + V | View Macros | ||
Filtering, Sorting & Validating ? | |||
Alt + A + SS | Sort Data | ||
Alt + A + SA | Sort Ascending | ||
Alt + A + SD | Sort Descending | ||
Ctrl + Shift + L | Filter Data | ||
Alt + A + Q | Advanced Data Filter | ||
Right Mouse Button + E + V | Filter by Cell’s Properties | ||
Alt + A + M | Remove Duplicates | ||
Alt + A + V + V | Validate Data | ||
Graphs & Charts ? | |||
Alt + N + C | Column Chart | ||
Alt + N + N | Line Chart | ||
Alt + N + Q | Pie Chart | ||
Alt + N + B | Bar Chart | ||
Alt + N + X | Text Box | ||
Alt + N + SD | Combo Chart (2013+) | ||
Alt + N + R | Recommended Chart (2013+) | ||
Alt + JC + A | Add Chart Element (2013+) | ||
Alt + JC | Design Tab | ||
Alt + JA | Layout Tab (2007, 2010) | ||
Alt + JO | Format Tab (2007, 2010) | ||
Alt + JA | Format Tab (2013) | ||
Formulas and Calculations ? | |||
= | Enter Formula | ||
F9 | Refresh All | ||
F4 | Anchor Cell | ||
Ctrl + F3 | Name Cell | ||
F5 | Jump to Cell | ||
Tab | Use Suggested Name | ||
Shift + F3 | Enter Built-In Function | ||
Ctrl + Alt + V + F | Paste Formulas | ||
Ctrl + Alt + V + R | Paste Formats & Formulas | ||
Ctrl + D | Copy Down | ||
Ctrl + R | Copy Right | ||
F5, Alt + S + F + X | Go to Formulas | ||
F5, Alt + S + O + X | Go to Constants | ||
Ctrl + ~ | Show Formulas on sheet |
For reading about Computer General Knowledge Questions then read this post to increase your gk about computer and technology.
Remember- Practice will Make you Perfect. So always do it for your examination success.
Leave a Comment