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
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment