Excel 2007 Shortcuts
-
- Ultimate Contributor
- Posts: 3700
- Joined: Nov 15, 2008
- Location: Buzy!!!
Excel 2007 Shortcuts
Apply the outline
border to the selected cells. [ Ctrl-Shift-& ]
Apply the Date format
with the day, month, and year.[ Ctrl-Shift-# ]
Apply the Time format
with the hour and minute, and AM or PM. [ Ctrl-Shift-@ ]
Enter the current
time. [ Ctrl-Shift-: ]
Enter the current
date. [ Ctrl-; ]
Hide the selected
rows. [ Ctrl-9 ]
Hide the selected
columns. [ Ctrl-0 ]
Alternate between
displaying cell values and displaying formulas in the worksheet. [Ctrl-` ]
Display the Find and
Replace dialog box, with the Replace tab selected. [ Ctrl-H ]
Display the Insert
Hyperlink dialog box for new hyperlink. [ Ctrl-K ]
Display the Print
Preview window. [ Ctrl-F2 ]
Switch to the next
workbook window. [ Ctrl-F6 ]
Display the Macro
dialog box to create, run, edit, or delete a macro. [ Alt-F8 ]
-
- Ultimate Contributor
- Posts: 6666
- Joined: Feb 17, 2007
- Location: Pakistan, Lahore
- Contact: