Shortcut keys of home tab in excel

2016 ~ Shortcut keys of Home Tab in excel

Friday 7 October 2016

Shortcut keys of Home tab in Excel



Every day we use excel, and we just want some handy rules by which we can use this amazing tool fluently and rapidly so today here I am going to share some basic shortcut keys of Home tab

Shortcut keys of Home Tab in Excel

1.       For applying border to whole data you have written in excel work book
a) Select the data (shift + arrow or ctrl +A)
b) Apply Border: Alt +H +B +A

2.       For applying Filter to your table :
a) Select the data (shift + arrow)
b) Apply Filter: Alt + D + F+ F or Alt + A +T

3.       For applying wrap text on a sheet :
a)       Select the data (shift + arrow)
b)       Apply Wrap Text : Alt + H +W

4.       For Merging Cells :
a)       Select the data (shift + arrow)
b)       Apply merge :
i)                     For merge & Centre : Alt +H +M + C
ii)                   For Merge across : Alt+ H + M + A
iii)                  For merge cells : Alt+ H + M + M
iv)                  For Unmerge cells : Alt+ H + M +  U

5.       For Changing font size:
a)       Select the data (shift + arrow)
b)       Chang Font Size : Alt + H+ FS

6.       For changing Font type :
a)       Select the data (shift + arrow)
b)       Change Font Type : Alt H +FF

7.       For changing alignment :
a)       Select the data (shift + arrow)
b)       Change alignment:
i)                     For left alignment : Alt + H +AL
ii)                   For Centre Alignment : Alt + H +AC
iii)                  For Right alignment : Alt + H+ AR

8.       For changing Font colour :
a)       Select the data (shift +arrow)
b)       Change font colour : Alt + H +FC

9.       For Highlighting cells :
a)       Select the data (shift + arrow)
b)       Highlight the cell : Alt + H + H

10.    For applying conditional formatting
a)       Select the data (shift + arrow)
b)       Apply conditional formatting : Alt + H + L