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