Pages

0

50 Excel Shortcuts



 Here we go with top 50 Excel shortcuts that will boost your productivity.

Description Shortcut
For copying CTRL + C
Cut CTRL + X
To paste CTRL + V
Paste special CTRL + ALT + V
Undo the last action CTRL + Z
Get back the last undone action. CTRL + Y
Select all the cells CTRL + A
To adjust the size of cells according to data length ALT + O + C + A
To tabulate the data CTRL + T
To edit the active cell F2
Go to the last column in same row CTRL + Right Arrow
Go to the last row in same column CTRL + Down Arrow
Add or Remove filter CTRL + Shift + L 
Clear the all applied filters ALT + A + C
Clear the all applied filters Alt + D + F + S
Clear one of the filters (move to that filter heading) Alt + down arrow + C
Custom Sort Alt + H + S + U
To apply all borders Alt + H + B + A
To apply Outline borders Ctrl + Shift + 7
To bold the data CTRL + B
To sum all the above values/left side values of active cell Alt + "="
To create a new workbook CTRL + N
To open a existing workbook CTRL + O
To find a value CTRL + F
To replace a value CTRL + H
To write some text in next line of the same cell ALT + Enter
To find enter CTRL + F and then
CTRL + J
To apply Italics to the data CTRL + I
To copy the data from left side of active cell CTRL + R
To copy the data from top cell of active cell CTRL + D
To save the file CTRL + S
To print the file CTRL + P
To insert a hyperlink CTRL + K
To Save As F12
To repeat the last action F4
Spell check F7
To activate the menu bar F10
To apply or remove wrap text Alt + H + W
To close Ctrl + F4
to toggle between workbooks Ctrl + Tab
To insert a new sheet in same workbook Shift + F11
To get the format cells pop up CTRL + 1
To get options like minimize, maximize, restore etc.  Alt + "space bar"
To merge cells Alt + H + M + C
To apply number separator on value in the selected cells Alt + H + K
To rename sheets Alt + H + O + R
To select an entire row Shift + "space bar"
To select an entire column CTRL + "space bar"
To insert a row (first select a row) CTRL + "+"
To insert a column (first select a column) CTRL + "+"

M P Naveen Chandra

Author pursued the Bachelor of Commerce from Nizam College, Hyderabad. He articulates his interests for informative purposes.

No comments:

Post a Comment