Important Excel Shortcut Keys for Your Regular Use

Important Excel Shortcut Keys for Regular Use

1) Ctrl + I                               = Italic

2) Ctrl + N                             = Create New Work Book

3) Ctrl + O                             = Open Existing Work Book

4) Ctrl + 9                              = Hide Selected Row

5) Ctrl + Shift + 9                 = Unhide Row

6) Ctrl + 0                              = Hide Selected Column

7) Ctrl + Shift + 0                 = Unhide Row

8) Ctrl + (+)                           = Add Rows & Columns

9) Ctrl + (-)                            = Delete Rows & Columns

10) Ctrl + C or Ctrl + Insert    = Copy

11) Ctrl + V                           = Paste

12) Ctrl + Alt + V                  = Past Special

13) Ctrl + X                           = Cut

14) Ctrl + B                           = Bold 

15) Ctrl + Z                            = Undo

16) Ctrl + Y                            = Redo

17) Ctrl + F1                          = Collapse and Expand Ribbon

18) Ctrl + U                           = Remove or Apply Underline

19) Ctrl + Shift + 5               = Convert to Percentage

20) Ctrl + T                            = Create Table

21) Ctrl + P                            = Print Dialog box

22) Ctrl + R                           = Copy and paste the content from Left side cell

23) Ctrl + D                           = Copy and paste the content from Above cell

24) Ctrl + O                           = Open Dialog box to find or open File

25) Ctrl + Shift + O              = Select all cells the contains Comment

26) Ctrl + K                           = Insert Hyperlink

27) Ctrl + H or Shift + F5    = Find & Replace

28) Ctrl + G or F5                 = Go to Dialog box

29) Ctrl + Shift + F               = Format Cells

30) Ctrl + 6                            = Hide or Show Objects

31) Ctrl + 5                            = Applies or Removes Strike Through

32) Ctrl + 4                            = Applies or Removes Underline

33) Ctrl + 3                            = Applies or Removes Italic

34) Ctrl + 2                            = Applies or Removes Bold     

35) Ctrl + 1                            = Format Selection

36) Ctrl + ;                             = Enter Current Date

37) Ctrl + :                             = Enter Current Time

38) Ctrl + A                           = Select Current Region

39) Ctrl + A (two Times)    = Select Entire work boos

40) Ctrl + Shift + L               = Toggle Filter

41) Ctrl + Home                   = Go to First Cell

42) Ctrl + End                       = Go to Last Non Blank Cell

43) Ctrl + Shift + 7               = Outline Border for Selected Cells

44) Ctrl + Shift + _               = Remove Outline Border

45) Ctrl + Shift + Arrow     = Select cells in the direction of arrow

46) Ctrl + Page up               = Go to Previous Sheet

47) Ctrl + Page Down         = Go to Next Sheet

48) Ctrl + Shift + 1               = Format as number with 2 d.p.

49) Ctrl + S                            = Save Active Work Book

50) Ctrl + W or Ctrl + F4    = Close the Active Work Book

Any Further Queries please feel Free to Contact us:

goodwilllearningworld@gmail.com

goodwilllearningworld@outlook.com

View and Subscribe to our YouTube Channel