Useful Short Cuts of Microsoft Excel | Microsoft Excel

Shortcuts are the basic need if you want to do efficient work on Microsoft Excel. It is a very helpful and fast way to do work using short cuts. Helps to no or less use of mouse can save a bit of time.

You can use Alt key to see the short cut on ribbon of Excel Sheet
short cut

When you press the Alt key the short cuts of all the menus are appeared on the screen like above image.
Now Using a key Alt + Shift + H
Which is a shortcut to the home accessibility tab
short cut
Now here \you can see all the short cuts of home tab
Same as you can use Accessibility shortcuts for the all the other tab given in below table
Download Excel Short cut Table here

Short cut

Description

Ctrl + G
Go To Specific Cell
Page Down or Down Arrow
Move Down
Page Up or Up Arrow
Move Up
Crtl + P
Print
Ctrl + C
Copy
Ctrl + V
Paste
Ctrl + Z
Undo
Ctrl +X
Cut
Ctrl +O
Open Workbook
Ctrl + W
Close Work book
Alt + F2
Save As
Ctrl +F or Shift + F3
Find
Ctrl + B
Bold
Alt + Q
Tell Me(Search option on the tittle bar)
Shift +F4
Repeat Find. Downward
Ctrl + Shift + F4
Repeat Find. Upward
Alt + F1
Insert Character
Cell Related Short Cuts
Alt + Win + H,I,R
Insert a row above the current row
Alt + Win + H,I,C
Insert a column to the left of the current column
Ctrl + X
Cut
Ctrl + C
Copy
Ctrl + V
Paste
Ctrl + Z
Undo
Ctrl + Y
Redo
Alt + Enter
Start a new line in  the same cell
Ctrl + K
Insert Hyperlink
Ctrl + L
Insert Table
Shift F3
Insert Function
Ctrl + Shift + >
Increase the Font Size
Ctrl + Shift + <
Decrease the Font Size
Alt + Win + A,T
Apply a Filter
Ctrl + Alt + L
Re Apply Filter
Data Related
Enter
Complete cell entry and select the cell below
Shift + Entre
Complete  cell entry and select the cell above
Tab
Complete the cell entry and select the next cell in the row
Shift + Tab
Complete the cell entry and select the Previous cell in the row
Esc
Cancel Cell entry
Edit Data Within cell
F2
Edit Selected Cell
F4
Cycle through all the combination of absolute and relative reference when a cell reference or range is selected in a formula
Delete
Clear Selected Cell
Backspace
Clear selected cell and start editing
Home
Go to beginning of cell line
End
Go to end of cell line
Shift + Right Arrow
Select right by character
Shift + Left Arrow
Select left by character
Shift + Home
Select to beginning of cell data
Shift + End
Select to end of data
Ctrl +Shift + Right Arrow
Ctrl + Shift + Left Arrow
Extend selection to the last non blank cell in the same column or row as the active cell, or if the next cell is blank, to the next non blank cell
Format Cell
Ctrl + B
Bold
Ctrl + I
Italics
Ctrl + U
Underline
Shift + Ctrl + V
Paste Formatting
Ctrl + Shift + &
Apply outline border to selected cell
Worksheet
Up Arrow or Shift + Enter
Up one cell
Down Arrow or Enter
Down one cell
Right Arrow or Tab
Move right one cell
Home
Go to the beginning of the row
Ctrl + Home
Go to A1 Cell
Ctrl +End
Go to the last cell of used range
Page Down
Move down one screen(28 cells)
Page Up
Move up one screen(28 cells)
Ctrl + Right Arrow  or Ctrl + Left Arrow
Move to the edge of the current region
Ctrl + F6
Move Between ribbon and workbook content
Tab
Move to d different ribbon tab(When you are in ribbon)
Shift + F11
Insert new sheet
Alt + Ctrl + Page Down
Switch to next sheet
Alt + Ctrl +Page Up
Switch to previous sheet
Object Related
Alt + Down
Open Menu  or Drill Down
Alt + Up Arrow
Drill Up
Ctrl + Enter
Follow Hyper link
Shift + F2
Open comment pane while editing
Select cells, rows and columns
Shift + Arrow keys
Select a range of cell
Ctrl + Space
Select Entire column
Ctrl + Shift + Right Arrow or
Ctrl + Shift + Left Arrow
Extend the selection to the last non blank cell in the3 same column or row
Move Within Selected range
Enter
From top to bottom
Shift + Enter
From bottom to top
Tab
Forward through a row
Shift + Tab
Back through row
Calculate Data
F9                                            
Calculate Workbook
Ctrl + Shift + Alt + F9
Full Calculate
Alt + F5
Refresh external data
Ctrl + Alt + F5
Refresh all external data
Alt + Equal(=)
Auto Sum
Accessibility Menu
Alt + Shift + F
File Accessibility
Alt + Shift + H
Home Accessibility
Alt + Shift + N
Insert Accessibility
Alt + Shift + P
Page Layout Accessibility
Alt + Shift + M
Formula Accessibility
Alt + Shift + A
Data Accessibility
Alt + Shift + R
Review Accessibility
Alt + Shift + w
View Accessibility
Alt + Shift + Y1
Help Accessibility
Alt + Shift + Y2
New Tab Accessibility
Alt + Shift + B
Power Pivot Accessibility


*These shortcuts are taken from the official website of Microsoft

2 comments:

  1. Hey what a brilliant post I have come a cross and believe me I have been searching out for this similar kind of post for past a week and hardly came across this.

    Excel pivot table calculated field

    ReplyDelete
  2. I have read your excellent post. This is a great job. I have enjoyed reading your post first time. I want to say thanks for this post. Thank you... blog link

    ReplyDelete