Last Updated on April 18, 2019 by GKQUESTIONBANK

---

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.

---

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

---