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 + OOpen FileCtrl + NNew File
Ctrl + PPrintCtrl + SSave File
F12Save File AsCtrl + F4Close File
Alt + F4Close ExcelEscExit Dialog
Ctrl + CCopyCtrl + XCut
Ctrl + VPasteCtrl + ZUndo
Ctrl + YRedoCtrl + ASelect All
Ctrl + FFindCtrl + HReplace
Alt + TabSwitch WindowsAlt + T + OOptions Menu
F4Repeat Last ActionCtrl + F1Show / Hide Ribbon Menu
Workbooks & Worksheets ?
Ctrl +  NNew Workbook
Ctrl + TabSwitch Workbook
Shift + F11New Worksheet
Alt + H + D + SDel Worksheet
Ctrl + PgUpMove to Left Worksheet
Ctrl + PgDnMove to Right Worksheet
Alt + H + O + MMove / Copy Worksheet
Shift + Ctrl + PgUp / PgDnSelect Multiple Worksheets
Alt + H + O + U + SHide Worksheet
Alt + H + O + U + HShow Worksheet
Alt + H + O + RRename Worksheet
Alt + H + O + TColor Tab
Rows & Columns ?
Ctrl + SpacebarSelect Column
Shift + SpacebarSelect Row
Ctrl + Shift + +Insert Cells / Rows / Columns
Ctrl + –Delete Cells / Rows / Columns
Right Mouse Button + EInsert Cut Cells and Shift Over
Alt + A + G + GGroup Rows / Columns
Shift + Alt + RightGroup Rows / Columns
Alt + A + U + UUngroup Rows / Columns
Shift + Alt + LeftUngroup Rows / Columns
Alt + A + JShow Grouped Rows / Columns
Alt + A + HHide Grouped Rows / Columns
Basic Formatting ?
Alt + HFormat Menu
Ctrl + 1Format Dialog
Ctrl + Alt + VPaste Special
Ctrl + Alt + V + TPaste Formats
Ctrl + Alt + V + VPaste Values
Ctrl + Alt + V + FPaste Formulas
Alt + H + FCFont Color
Alt + H + HFill Color
Alt + H + BBorder Options
Alt + H + A + L / C / RAlign Left / Center/ Right
Alt + H + 6Increase Indent
Alt + H + 5Decrease Indent
Alt + H + 0Increase Decimal Places
Alt + H + 9Decrease Decimal Places
Ctrl + BBold
Ctrl + IItalics
Ctrl + UUnderline
Ctrl + 5Strikethrough
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 KeysMove Around
Ctrl + ArrowsJump to Boundary
Shift + ArrowsSelect Cells
Shift + Ctrl + ArrowsSelect to Boundary
Shift + F8Select Multiple Areas
Editing Cells ?
F2Edit Cell
DelDelete Cell Contents
Ctrl + ArrowsSkip Word(s)
Ctrl + Shift + ArrowsHighlight Word(s)
Alt + EnterNew Line in Cell
Displays cell using custom format ?
Alt + H + O + IAuto-Fit Col.
Alt + H + O + AAuto-Fit Row
Alt + H + O + WColumn Width
Alt + H + O + HRow Height
Alt + H + L + RConditional Formatting
Alt + H + TFormat as Table
Common Built-In Functions ?
=SUMSum Numbers
Alt + =Sum Adjacent Cells
=COUNTCount # Entries
=AVERAGEAverage
=MAXMaximum
=MINMinimum
=SUMIF / =SUMIFSConditional Sum
=COUNTIF / =COUNTIFSConditional Count
=SUMPRODUCTMultiply and Sum Range
=ABSAbsolute Value
=IFConditional
=OROne Must Be True
=ANDAll 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 + PTrace Precedents
Alt + M + DTrace Dependents
Alt + M + A + AErase Traces
Shift + Ctrl + {All Precedents
Shift + Ctrl + }All Dependents
F5 + EnterJump to Original Cell
Shift + F2Add/Edit Comment
Alt + R + DDel Comment
Alt + R + AShow All Comments
F5, Alt + S + CHighlight Cells w/ Comments
Macros, VBA, and Forms ?
Alt + F11VBA Editor
F5 (in VBA)Run Macro
F2 (in VBA)Object Browser
Ctrl + G (in VBA)Immediate Window
Alt + L + IForm Control
Alt + W + M + UUse Relative References
Alt + W + M + RRecord Macro
Alt + W + M + VView Macros
Filtering, Sorting & Validating ?
Alt + A + SSSort Data
Alt + A + SASort Ascending
Alt + A + SDSort Descending
Ctrl + Shift + LFilter Data
Alt + A + QAdvanced Data Filter
Right Mouse Button + E + VFilter by Cell’s Properties
Alt + A + MRemove Duplicates
Alt + A + V + VValidate Data
Graphs & Charts ?
Alt + N + CColumn Chart
Alt + N + NLine Chart
Alt + N + QPie Chart
Alt + N + BBar Chart
Alt + N + XText Box
Alt + N + SDCombo Chart (2013+)
Alt + N + RRecommended Chart (2013+)
Alt + JC + AAdd Chart Element (2013+)
Alt + JCDesign Tab
Alt + JALayout Tab (2007, 2010)
Alt + JOFormat Tab (2007, 2010)
Alt + JAFormat Tab (2013)
Formulas and Calculations ?
=Enter Formula
F9Refresh All
F4Anchor Cell
Ctrl + F3Name Cell
F5Jump to Cell
TabUse Suggested Name
Shift + F3Enter Built-In Function
Ctrl + Alt + V + FPaste Formulas
Ctrl + Alt + V + RPaste Formats & Formulas
Ctrl + DCopy Down
Ctrl + RCopy Right
F5, Alt + S + F + XGo to Formulas
F5, Alt + S + O + XGo 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.


 

You may also like...

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.