Top 25 Excel Tips, Tricks, and Shortcuts for Beginners
 |
| Top 25 Excel Tips, Tricks, and Shortcuts for Beginners |
01. Basic Ctrl Shortcuts
Ctrl + New - Create New file
Ctrl + Open - Open
existing file
Ctrl + Workbook – Close Workbook
Ctrl + Save - Save
current file
Ctrl + Copy – Copy
selection
Ctrl + X– Cut selection
Ctrl + V- Paste from clipboard
Ctrl + Find - Open Find
dialog box Ctrl + H– Open Replace dialog box Ctrl + Print - Open Print
dialog box Ctrl+ All – Select All
contents
Ctrl + Table - Insert Table
Ctrl + Bold - Toggle Bold
selection Ctrl + Italic - Toggle Italic
selection Ctrl + Underline - Toggle Underline selection Ctrl + Z - Undo action
02. Basic Windows shortcuts:
Win + Desktop
Win + Explorer
Win + Inventory
Win + Lock
03. Windows Alt Shortcut
Alt + ⮀ Switch between active windows
04. Charts
Alt + F1 Create Default Chart in current sheet F11 Create Default Chart in new sheet
05. Filters
Alt + A Turn On/Off Filter
Alt + A Clear the Filter
06. ZOOM
Ctrl + Scroll Up mouse wheel - Zoom In Ctrl + Scroll Down mouse wheel - Zoom Out
07. Insert current Date and Time
Ctrl ; Insert current Date
Space
Ctrl : Insert current Time
Enter
08. FILL
Ctrl D - Fill Down command to copy the contents and format from cell above
Ctrl R Fill Right command the contents and format from cell left
09. Pivot Tables
ALT + N + V - Insert New Pivot Table
ALT + D + P - PivotChart Wizard
10. Visual Basic for Application (Macros)
Alt + F8 - View Macros
Alt + F11 - Open The Visual Basic Editor
11. Function Key Shortcuts
F1 Open Help menu
F2 Edit selected cell
F3 Paste Names menu
F4 Repeat last action or toggle references if you edit the cell
F5 Open Go to Menu
F6 Next Pane
F7 Spell Check
F8 Extend mode
F9 Recalculates Workbook
F10 Active Menu Bar
F11 Create Default Chart in separate sheet F12 Save as …
12. Shortcuts to insert or delete column(s)Ctrl + Space Select column Shift + 🡨 or → Select more
Ctrl + + Insert selection new columns Ctrl + - Delete selection
Alt + I C Inserts Column before selected cell
13. Shortcuts to insert or delete row(s) Shift +Select row
Shift + 🡩 or 🡫 Select more rows
Ctrl + + Insert selection new rows Ctrl + - +Delete selection
Alt + I R - Inserts Row above selected cell
14. Navigation shortcuts
Ctrl + Home Move to the first not frozen cell in worksheet
Ctrl + End
Move to the last unused cell in the bottom-most row
Ctrl + 🡨 or 🡩 or 🡫 or →
Move to appropriate edge of data region
Ctrl + PgUp
Move to the next sheet in the workbook
Ctrl + PgDn
Move to the previous sheet in the workbook
15. Selection shortcuts
Ctrl Shift + Home
Select range to the first not frozen cell in worksheet
Ctrl Shift + End
Select range to the last unused cell in the bottom-most row
Ctrl Shift + 🡨 or 🡩 or 🡫 or →
Select range to appropriate edge of data region
16. Formating Selelcted Cells
Example type 1.5
Ctrl
+ $ Currency £1.50
+ % Percent 150%
+ ! Comma 1.50
+ # Date 05 Jan 1900 + @ Time 12:00
+ ~ General 1.5
+ ^ Exponent 1.50E+00
17. Paste Special Shortcuts
Alt + E S - Open Paste Special Dialogue Box & Value & Enter
& Formulas & Enter
& T - Formats & Enter
& Comment & Enter
& E - Transpose & Enter
& N - Validation & Enter
Download
People also search for
1.Excel tricks and shortcuts pdf 2.250 Excel shortcuts PDF 3.1000 Excel shortcuts PDF 4.MS Excel shortcuts and formulas PDF 5.Excel shortcut keys formula 6.Excel shortcut keys A to Z 7.Excel formulas PDF
8.50 shortcut keys of MS Excel
What are the 20 shortcut keys in Excel?
What are the 50 shortcut keys?
Post a Comment