5/27/10

Excel 2007 Shortcuts

Here are some great tips for Excel user's in version 2007

Alt+Shift+F1 — inserts a new worksheet
F6 — switches between the worksheet, Ribbon, task pane and Zoom controls
Ctrl+F6 — switches to the next workbook window when multiple workbook windows are open
Ctrl+’ — alternates between displaying the value of a cell and the formula
Ctrl+shift+: — enters the current time into selected cells
Ctrl+Shift+$ — enters the currency format to selected cells
Ctrl+Shift+# — enters the date format using day, month, and year
Ctrl+; — enters the current date into selected cells
Ctrl+D — applies the fill down command to selected cells
Ctrl+R — applies the fill right command to selected cells