100 Keyboard shortcuts for Excel
Learn some useful Excel keyboard shortcuts to work much faster and improve efficiency
Email: Support@skillfinlearning.com
Mobile: 9650010925
Shortcuts using Control and alphabet keys (A-Z) Select All Bold Copy Fill cell beneath Find Go To Find & replace Italic Insert Hyperlink Create Table New Blank Excel File
Email: Support@skillfinlearning.com
Control Control Control Control Control Control Control Control Control Control Control
& & & & & & & & & & &
A B C D F G H I K L N
Open Existing workbook Print Conditional formatting Fill cell to right Save Create Table Underline selected text Paste Cut Redo Undo
Mobile: 9650010925
Control Control Control Control Control Control Control Control Control Control Control
& & & & & & & & & & &
O P Q R S T U V X Y Z
Function Key shortcuts
Help
F1
Insert a Chart
Alt & F1
Edit a cell
F2
Close a file
Alt & F4
Absolute/Relative referencing
F4
Insert Comment
Shift & F2
Repeat the previous command
F4
Insert Formula
Shift & F3
Go To
F5
Find & Replace
Shift & F5
Save As
F12
Insert Worksheet
Shift & F11
Email: Support@skillfinlearning.com
Mobile: 9650010925
Other shortcuts Format a cell
Control & 1
Hide selected columns
Control & 0
Control & Page Up/Page Down
Unhide selected rows
Control & Shift & 9
Control & Arrow Keys
Insert a row/ column
Control & Shift & +
Copy format
Control & Shift & C
Insert a row/ column
Control & -
Paste Format
Control & Shift & V
Insert current date
Control & ;
Control & Home
Insert current Time
Control & Shit & ;
Scroll between different sheets Scroll through work sheet
Go to the beginning of the sheet Go to End of the sheet
Control & End
Insert Sum
Show value as Date
Control & Shift & 3
Select entire row
Show value as $ amount
Control & Shift & 4
Select entire column
Show value as Percentage
Control & Shift & 5
Navigate between open workbooks
Hide selected rows
Email: Support@skillfinlearning.com
Control & 9
Navigate between applications
Mobile: 9650010925
Alt & = Shift & Space Control & Space Control & Tab Alt & Tab
Power of Alt Key When we press the Alt Key; we see the shortcuts for the Tabs/buttons in the menu bar
Alt & N for Insert Alt & F for File
Alt & R for Review Alt & M for Formulas
Alt & H for Home
Email: Support@skillfinlearning.com
Alt & Y & 2 for Camera
Alt & A for Data Alt & P for Page Layout
Alt & W for View Mobile: 9650010925
Alt & L for Developer
Alt & Y & 1 for Help Alternatively Help can also be activated by pressing F1
Some examples using Alt Key (1/2) Select Font
Alt & H & FF
Insert Charts
Alt & N & R
Select Font Size
Alt & H & FS
Insert Pivot Table
Alt & N & V
Font color
Alt & H & FC
Insert Worksheet
Alt & I & W
Fill Color
Alt & H & H
Delete Worksheet
Alt & E & L
Merge Cells
Alt & H & M
Paste Special
Alt & E & S & V
Insert Shape
Alt & N & SH
Paste Format
Alt & E & S & T
Insert Table
Alt & N & T
Paste Special - Transpose
Insert Picture
Alt & N & P
Paste Formula
Email: Support@skillfinlearning.com
Mobile: 9650010925
Alt & E & S & V & E Alt & E & S & F
Some examples using Alt Key (2/2) Name Manager
Alt & M & N
What-if-Analysis
Trace Precedents
Alt & M & P
Goal Seek
Alt & A & W & G
Trace Dependents
Alt & M & D
Data Table
Alt & A & W & T
Sort Ascending
Alt & A & SA
Group rows/ columns
Alt & A & G
Sort Ascending
Alt & A & SD
Ungroup rows/ columns
Alt & A & U
Filter
Alt & A & T
Zoom
Alt & W & Q
Advance Filter
Alt & A & Q
Freeze Panes
Alt & W & F
Text to column
Alt & A & E
Insert Sum
Email: Support@skillfinlearning.com
Mobile: 9650010925
Alt & A & W
Alt & =
Paste Special shortcut Paste Special
Alt & E & S
Email: Support@skillfinlearning.com
Mobile: 9650010925
Want to learn more? Explore our Data Analysts Skills Training (DAST) in Excel Go from beginner to an Expert in Data analytics Skills in Excel. Join this program to build your Excel analytical skill quickly through hands on project Includes: Annual (1 year) access Take the program anytime anywhere Direct access to the instructor Weekly mentorship assistance 6.5 hours on-demand HD videos 20+ real life case illustrations 5 Practice assignment Access on Mobile and Tablet Certificate of Completion 30-day money back guarantee
Email: Support@skillfinlearning.com
You get a Personalized Training Experience: Unlimited access to video content 1 on 1 coaching from expert instructor Individual mentorship assistance Dedicated doubts resolution sessions Practice on real world projects from industry experts Evaluation and feedback on assignments For more details please visit; Data Analyst Skills Training in Excel (DAST)
Mobile: 9650010925
THANK YOU
Email: Support@skillfinlearning.com
Mobile: 9650010925
Visit us: www.skillfinlearning.com Chat with us: +91 96500 10925 Email us: support@skillfinlearning.com