While working with Microsoft Excel, you must have came across the situation where you want to find efficient way of working with Excel and to improve the existing skills.
Keyboard Shortcuts Guide will help you build your interest in Microsoft Excel and would take your skills to next level. This will also help to increase existing productivity level so that saved time can be utilized in learning new skills.
So Keep reading the article to add values to your existing knowledge…

Common Used Excel Shortcuts

Shortcut
Performance
Alt+A
Go to Data tab
Alt+H
Go to the Home tab
Alt+H+A+C
Center align cell contents of active cell or selected range
Alt+H+B
Add borders to active cell or selected range
Alt+H+D+C
Delete active cell’s column
Alt+H+H
Choose a fill color to active cell or selected range
Alt+M
Go to Formula tab
Alt+N
Go to Insert tab
Alt+P
Go to Page Layout tab
Alt+W
Go to View tab
Ctrl+0
Hide the selected columns
Ctrl+9
Hide the selected rows
Ctrl+B
Apply or Remove Bold of text or active cell or selected range
Ctrl+C
Copy active cell or selected range
Ctrl+O
Open new workbook
Ctrl+S
Save active workbook
Ctrl+V
Paste content to active cell, which is copied (i.e. Ctrl+C)
Ctrl+W
Close active workbook
Ctrl+X
Cut or move the active cell or selected cell range
Ctrl+Z
Undo the last command/action
Delete
Delete/Remove the content from active cell or selected range
Shift+F10
Open context menu i.e. menu opens with right click

Shortcuts for Excel Formatting

Shortcuts
Performance
Ctrl+1
Open Format Cells dialog box window
Ctrl+Shift+F or Ctrl+Shift+P
Open Format Cells dialog box window with Font Tab
F2
Edit active cell
Shift+F2
Insert/Open/Edit Comment box in active cell
Ctrl+Shift+F2
Insert/Open/Edit Threaded comment box in active cell
Ctrl+Shift+Plus sign (+)
Open the Insert dialog box to insert blank cells or entire row/column
Ctrl+Minus sign (-)
Open the Insert dialog box to delete blank cells or entire row/column
Ctrl+Shift+colon (:)
Insert current time in active cell
Ctrl+semi-colon (;)
Insert current date in active cell
Ctrl+grave accent (`)
Show/hide formula or value in active sheet
Ctrl+apostrophe (‘)
Insert same formula or cell value of above cell in the active cell
Ctrl+X
Cut or move the active cell or selected cell range
Ctrl+C
Copy the active cell or selected cell range
Ctrl+V
Paste the content which is Copied (Ctrl+C) or to be moved (Ctrl+X)
Ctrl+Alt+V
Open Paste Special dialog box
Ctrl+I or Ctrl+3
Change/Remove font style to Italic for active cell or selected range
Ctrl+B or Ctrl+2
Apply or Remove Bold of text or active cell or selected range
Ctrl+U or Ctrl+4
Apply or remove Underline of the text or active cell or selected range
Ctrl+5
Apply or remove strike-through
Ctrl+6
Hide or Unhide objects in active sheet
Ctrl+Shift+ampersand (&)
Apply an outline border to active cell or selected cells
Ctrl+Shift+underline (_)
Remove outline border to active cell or selected cells
Ctrl+8
Display or hide the outline symbols
Ctrl+D
Fill down the active sheet with values or formulas or formatting of above cells
Ctrl+Shift+tilde sign (~)
Apply General number formatting
Ctrl+Shift+dollar sign ($)
Apply USD ($) Currency symbol with two decimal places
Ctrl+Shift+percent sign (%)
Apply Percentage formatting
Ctrl+Shift+caret sign (^)
Apply the Scientific number formatting
Ctrl+Shift+number sign (#)
Apply the Date formatting with the day, month and year
Ctrl+Shift+at sign (@)
Apply the Time formatting with the hour and minute, and AM or PM.
Ctrl+Shift+exclamation point (!)
Apply the Number formatting with two decimal places, thousands separator
Ctrl+K
Open Insert hyperlink dialog box
F7
Perform spell check in active worksheet or selected range
Ctrl+Q
Display the Quick Analysis options for selected data range
Ctrl+L or Ctrl+T
Open Create Table dialog box
Ctrl+Shift+G
Open the Workbook Statistics dialog box
Alt+Enter
Insert a new line in active editing cell
Ctrl+A or Ctrl+Shift+Spacebar
Select the cell range around the active cell
Ctrl+Enter
Complete the entry in editing cell without changing cell position
Ctrl+Shift+Arrow key
Increase the selection range till next cell with value
Ctrl+Shift+Asterisk (*)
Select the cells around active cell
Ctrl+Shift+Home
Increase the selection to cells till beginning of active sheet
Ctrl+Shift+Page Down
Select active and next sheet
Ctrl+Shift+Page Up
Select active and previous sheet
Ctrl+Spacebar
Select entire column of active cell
Ctrl+Y
Repeat the command which was Undo (in Ctrl+Z)
Ctrl+Z
Undo the last command/action
Shift+Arrow key
Increase the selection range to by one cell
Shift+Enter
Change active cell position to cell above
Shift+Spacebar
Select entire row of active cell

Excel Formulas Shortcut

Shortcut
Performance
Alt+F1
Create a chart for selected range of cells in active sheet
Alt+F11
Open the Microsoft Visual Basic
Alt+F8
Macro related (i.e. Create, edit, run or delete)
Ctrl+A
Select the cells around active cell
Ctrl+End
Move cursor to next cell with value or Go to end of text when editing in formula bar
Ctrl+Shift+End
Select the cells till next cell with value
Ctrl+Shift+U
Increase/decrease width of formula bar
Enter
Complete the transaction and go to down cell
Esc
Ignore/cancel the value in active excel cell
F11
Create a chart for selected range of cells in separate sheet
F2
Edit active excel cell
F4
Change the references (absolute/relative) in function in active cell
F9
Perform function calculations in open worksheets
Shift+F3
Open Insert function dialog box to Insert the function in active cell
Shift+F9
Perform function calculation in active worksheet

Leave a Reply

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