Most Important Keyboard Shortcuts MS Excel


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 Print 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.


Read More GK

Current Affairs 2017 Computer GK
Current Affairs 2016 GK in Hindi
Science GK History GK
Constitution GK Uttarakhand GK
Solved Papers GK UPSC Questions for Practice
Economics GK Geography GK
Important Question for SSC Railway Exams Important GK
Question Banking GK Political Science GK

Remember- Practice will Make you Perfect. So always do it for your examination success.


You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *