Excel Shortcut Keys for Beginner and Advanced

excel-shortcut-keys-beginner-simplemsoffice

In this post, we are providing shortcut keys that can be used in your daily office work, especially in Excel Work. You can save lots of time by using these keys. Some of them you may already be aware of. These shortcut keys can be used for Formatting, Working with Workbooks, Calculation, and Special Symbols or Characters.

If you have any shortcut keys other than these, then you can write to us in the comment box.

Formatting Keys

Shortcut Key Function
Alt + ‘   Display the Style Dialog Box
Ctrl + b Bold
Ctrl + i Italic
Ctrl + u Underline
Ctrl + 9 Hide Rows
Ctrl + 1 Format Dialog Box
Ctrl + 5 Strike-Through
Ctrl + x/c/v Cut/Copy/Paste
Ctrl + d/r File Cells Down/Right
Ctrl + 0 Hide Columns
Ctrl + Shift + 0 Unhide Columns
Ctrl + Shift + 9 Unhide Rows
Ctrl + Shift + ~ General Number Format
Ctrl + Shift + $ Currency Format
Ctrl + Shift + % Percentage Format
Ctrl + Shift + ! Comma Format
Ctrl + Shift + & Outline Border
Ctrl + Shift + _ Remove Borders
Ctrl + Shift + L Enable/Disable the Filter on the columns
Ctrl + ; Insert Date
Ctrl + Shift + ; Insert Time
Alt + D + L Data Validation Dialog Box
Shift + Space Select the Entire Row
Ctrl + Space Select the Entire Column
Ctrl + A Select the Entire Worksheet
Ctrl + Shift + * Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)
Shift + Arrow Key Extend the selection by one cell
Ctrl + Shift + Arrow Key Extend the selection to the last nonblank cell in the same column or row as the active cell
Shift + Home Key Extend the selection to the beginning of the row
Ctrl + Shift + Home Key Extend the selection to the beginning of the worksheet
Ctrl + Shift + End Key Extend the selection to the last cell used on the worksheet (lower-right corner)

Windows Workbook Keys

Shortcut Key Function
Ctrl + F4 Closes Workbook Window
Alt + F4 Closes Excel
Ctrl + F10 Maximizes the Workbook
Ctrl + F9 Minimizes the Workbook
Ctrl + F5 Restore Window Size
F6 Next Pane
Shift + F6 Previous Pane
Ctrl + F6 Next Window
Ctrl + Tab Next Window
Shift + F11 Inserts a New Sheet
F11 Create a Quick Chart Sheet
Ctrl + S Saves the Workbook
F12 Saves As
Ctrl + O Opens a Workbook
Ctrl + N Creates a New Workbook
Alt + F8 Macros Dialog Box
Alt + F11 Visual Basic Editor
ALT + TAB Switch Between Applications
Ctrl + TAB Switch Between Open Excel Files
Ctrl + Arrow Key Go to the next empty cell
Ctrl + Home/End Key Go to the First/Last Cell of the Worksheet
Ctrl + Page Up/Page Down Key Go to Previous/Next Worksheet

Auditing and Calculation Keys

Shortcut Key Function
Ctrl + ‘ ( ~ )   Toggle Formula Display
Ctrl + [   Selects cells directly referred to by formulas (Precedent Cells)
Ctrl + Shift + {  Selects, directly and indirectly, referred-to cells
Ctrl + ]   Selects only cells with formulas that refer directly to the active cell (Dependent Cells)
Ctrl + Shift + }  Selects all cells within formulas that directly or indirectly refer to the active cells
F9   Calculate all worksheets
Shift + F9   Calculate worksheet
F2   Toggle cell edit mode
Shift + Backspace   If multiple cells are selected, select only the active cell
Shift + Page Down Key  Extend the selection down one screen
Shift + Page Up Key  Extend the selection up one screen
Ctrl + Shift + Spacebar With an object selected, select all objects on a sheet
 Ctrl + 6   Alternate between hiding objects, displaying objects, and displaying placeholders for objects
Ctrl + 7   Show or hide the Standard toolbar

Special Character Insert Shortcut Keys

Shortcut Key Function
Alt + 0128  
Alt + 0131   ƒ
Alt + 0134  
Alt + 0135  
Alt + 0139  
Alt + 0153  
Alt + 0163   £
Alt + 0165   ¥
Alt + 0166   ¦
Alt + 0169   ©
Alt + 0171   «
Alt + 0174   ®
Alt + 0177   ±
Alt + 0178   ²
Alt + 0179   ³
Alt + 0181   µ
Alt + 0188   ¼
Alt + 0189   ½
Alt + 0190   ¾
Alt + 0247   ÷

 


 

0 Comments

Leave a Comment

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