Excel 2007 Shortcuts - Very very useful

[Kannan the Great]

Dear Karthik,

 

Recently I have received the below shortcuts which are very useful.

 

 Excel 2007 Shortcuts

 

1. Apply the outline border to the selected cells. [ Ctrl-Shift-& ]
2. Apply the Date format with the day, month, and year.[ Ctrl-Shift-# ]
3. Enter the current time. [ Ctrl-Shift-: ]
4. Enter the current date. [ Ctrl-; ]
5. Hide the selected rows. [ Ctrl-9 ]
6. Hide the selected columns. [ Ctrl-0 ]
7. Alternate between displaying cell values and displaying formulas in the worksheet. [ Ctrl-` ]
8. Display the Find and Replace dialog box, with the Replace tab selected. [ Ctrl-H ]
9. Display the Insert Hyperlink dialog box for new hyperlink. [ Ctrl-K ]
10. Display the Print Preview window. [ Ctrl-F2 ]
11. Switch to the next workbook window. [ Ctrl-F6 ]
12. Display the Macro dialog box to create, run, edit, or delete a macro. [ Alt-F8 ]

 

Pls ask our members to donate some other tips.

 

Regards,

 

Kannan

 

+--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--++--+