MS Excel Shortcuts

You may want to keep below set of key sequences handy as it can definitely improve your productivity while working with Excel.

Task	Key Sequence
Hide Column	[Ctrl] + [0]
Unhide Column	[Ctrl] + [Shift] + [0]
Hide Row	[Ctrl] + [9]
Unhide Row	[Ctrl] + [Shift] + [9]
Refresh	[Ctrl] + [6]
Strike Out	[Ctrl] + [5]
Underline	[Ctrl] + [4]
Italic	[Ctrl] + [3]
Bold	[Ctrl] + [2]
Format Cell Dialog	[Ctrl] + [1]
Change Relative Cell Ref to Absolute ref. (Toggle Key)	[F4]
Edit Current Cell	[F2]
vzGo To a Cell	[F5]
Toggle between Show Formula/Normal Mode in whole worksheet (Toggle Key)	[Ctrl] + [`]
Close Current Workbook	[Ctrl] + [w]
Copy Contents of Cell to Left	[Ctrl] + [R]
Create Table and set filters	[Ctrl] + [L] Or [Ctrl] + [T]
Insert Hyperlink Dialog	[Ctrl] + [K]
Current Date	[Ctrl] + [;]
Current Time	[Ctrl] + [:]
Copy Contents of Cell above current selection	[Ctrl] + [']
New Workbook	[Ctrl] + [N]
Delete Selected Cell	[Ctrl] + [-]
Insert Blank Cell	[Ctrl] + [=]
Auto Sum	Alt + [=]
Complete Formula with parenthesis and parameters	[Ctrl] + [Shift] + [A]
Toggle between open workbooks	[Ctrl] + [TAB]
Open Worksheet to left of current worksheet	[Ctrl] + [PgUP]
Open Worksheet to right of current worksheet	[Ctrl] + [PgDn]
Box the Current Selection	[Ctrl] + [Shift] + [7] or [Ctrl] + [&]

I hope you found the information useful and Thank you for reading.