Computer Helpers from Boreham Library

Tips, Hints and Links for University of Arkansas - Fort Smith Students, Faculty and Staff

Excel 2007 shortcuts

Posted by dvanarsd on May 16, 2008

PC Magazine (June 200 8) has a list of “11 Killer Excel 2007 Shortcuts”:

Ctrl-Shift-& Apply the outline border to the selected cells
Ctrl-Shift-# Apply the Date format with day, month and year
Ctrl-Shift-@ Apply the Time format: hour, minute, AM or PM
Ctrl-Shift-: (colon) Enter current time
Ctrl-; (semi-colon) Enter date
Ctrl-O Hide selected columns
Ctrl-’ (single quote) alternate: cell values/formulas
Ctrl-H Find and replace
Ctrl-F2 Print Preview
Ctrl-F6 next workbook
Alt-F8 macro dialog box

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>