50 shortcut keys of ms excel | ms excel shortcut keys by getready

 50 shortcut keys of ms excel | ms excel shortcut keys by getready



Here's a table with 50 commonly used Microsoft Excel shortcuts:

Command Explanation

Shortcut Key Combination

Save workbook

Ctrl + S

Copy    

Ctrl + C

Cut       

Ctrl + X

Paste    

Ctrl + V

Undo   

Ctrl + Z

Redo    

Ctrl + Y

Select all            

Ctrl + A

Find      

Ctrl + F

Replace

Ctrl + H

Insert hyperlink

Ctrl + K

Insert current date

Ctrl + ;

Insert current time

Ctrl + Shift + ;

Insert column

Ctrl + Shift + +

Insert row

Ctrl + Shift +

Delete column 

Ctrl +

Delete row

Ctrl + Shift + =

Move to next sheet

Ctrl + Page Down

Move to previous sheet              

Ctrl + Page Up

AutoSum           

Alt + =

Insert function

Shift + F3

Format cells      

Ctrl + 1

Bold     

Ctrl + B

Italicize

Ctrl + I

Underline          

Ctrl + U

Strikethrough

Ctrl + 5

Increase font size          

Ctrl + Shift + >

Decrease font size

Ctrl + Shift + <

Align text left

Ctrl + L

Align text center             

Ctrl + E

Align text right 

Ctrl + R

Merge cells       

Ctrl + Shift + +

Unmerge cells  

Ctrl + Shift +

Hide column     

Ctrl + 0

Unhide column

Ctrl + Shift + 0

Hide row           

Ctrl + 9

Unhide row      

Ctrl + Shift + 9

Insert new worksheet   

Shift + F11

Calculate active worksheet

F9

Insert new chart            

F11

Go to next worksheet tab          

Ctrl + Page Down

Go to previous worksheet tab   

Ctrl + Page Up

Select entire column     

Ctrl + Spacebar

Select entire row            

Shift + Spacebar

Open the formula bar

Ctrl + Shift + U

Apply number format (general)

Ctrl + Shift + ~

Apply number format (currency)             

Ctrl + Shift + $

Apply number format (percentage)     

Ctrl + Shift + %

Apply number format (date)     

Ctrl + Shift + #

Apply number format (time)     

Ctrl + Shift + @

These are just a few examples of the many shortcuts available in Microsoft Excel. Remember that some shortcuts may vary depending on the version of Excel or your operating system.

50 shortcut keys of ms excel | ms excel shortcut keys by getready