Author Topic: 12 Killer Excel 2007 Shortcuts  (Read 1328 times)

Offline tanvir_hasnat

  • Newbie
  • *
  • Posts: 38
    • View Profile
12 Killer Excel 2007 Shortcuts
« on: January 31, 2009, 06:14:29 PM »
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 ]

Md. Tanvir Hasnat
Faculty of Business and Economics
Marketing
Department of Business and Economics
Daffodil International University