September 30, 2008

Following are one of the best shortcuts of MS Excel :

1. Outline border to the selected cells – Ctrl Shift &
2. Change Date format with day, month, and year – Ctrl Shift #
3. Change Time format with hour and minute, AM or PM – Ctrl Shift @
4. For the current time – Ctrl Shift :
5. For current date – Ctrl ;
6. Hide selected rows – Ctrl 9
7. Hide selected columns – Ctrl 0
8. Display Farmulas / Alternate in the worksheet – Ctrl `
9. Display the Find / Replace dialog box – Ctrl H
10.To insert Hyperlink – Ctrl K



If you have any computer related problem, you can ask it at our Question & Answer portal and our experts will answer your queries.

About

Bishwajeet Mahato is the Founder and CEO of Comptalks, an online portal and offline college magazine.He is a fifth year undergraduate student of IIT Kharagpur,India and he loves writing about technology and helps people solve their computer related problems. Nowadays, he is also interested in digital marketing and has worked for several top notch companies. Follow him on Twitter @mahato99

Comments:
  1. Ooh! I love keyboard shortcuts. I know a bunch for Word but not as many for Excel. Thanks!

    Copyright © 2011 Comptalks - All Rights Reserved.