Microsoft Excel is widely used in daily routine. Even, if we are good in excel, we can make a big difference in our speed and can save much time and increase work efficiency by using shortcut key in excel.
Let’s start,
To Select All = Ctrl+A
To Bold = Ctrl+B
To Copy = Ctrl+C
To Fill down = Ctrl+D
To find content in sheet = Ctrl+F
To Go to = Ctrl+G ( This shortcut is used to go to a specific cell by just typing the cell number, instead of going through scrolling down and up. Suppose you are working in a excel sheet with huge data and you need to go to cell no. D1500 from D1 and come back by scrolling the mouse, it take a long time, press Ctrl+G and type the cell no. D1500 to come back D1)
To Replace a text or number with another one = Ctrl+H
To make content Italic = Ctrl+I
To insert Hyperlink = Ctrl+K
To open a new workbook = Ctrl+N
To open a saved file = Ctrl+O
To print a page = Ctrl+P
To Fill Right = Ctrl+R
To save opened file = Ctrl+S
To underline = Ctrl+U
To paste a copied/cut content Ctrl+V
To close opened file = Ctrl+W
To cut selected data = Ctrl+X
To repeat = Ctrl+Y
To undo = Ctrl+Z
To help = F1
To edit = F2
To paste name = F3
To repeat last action = F4
To Go to = F5 (Ctrl+G)
To next pane = F6
To check Spelling = F7
To Extend mode = F8 (Normally we use Shift+ Arrow to select multiple cells)
To recalculate the output of formula = F9
To Display Keyboard shortcuts (Activate Menu bar = F10