Productivity Cheat Sheet 2: Excel - 1

Microsoft Excel has made spreadsheeting a way of life for a lot of us. Yet few of us can really fathom the mind boggling number of shortcuts and commands in this amazing application. So in the next few cheat sheet episodes we're going to be concentrating on productivity quickies this app—for newbies to nitros. We'll be zipping our way around function and combo key shortcuts for formulas, movement, cell selection and all that jazz to snazz up your worksheet efficiency.

F1: Launches Help
F2: Edits current cell
F5: Goto
F7: Launches spell check
F12: Saves file as
Alt + =: Autosums
Alt + F8: Macros
Ctrl + F: Displays the Find dialog
Ctrl + H: Displays the Replace dialog
Ctrl + Y: Redos the last undone action
Ctrl + 1: Displays Format Cells dialog
Ctrl + ;: Inserts Current Date
Ctrl + :: Inserts Current Time
Home: Goes to beginning of row
Ctrl + Home: Goes to top of worksheet (A1)
Ctrl + End: Goes to end of worksheet
Ctrl + PgDn: Goes to next worksheet
Ctrl + Spacebar: Selects the entire column
Shift + Spacebar: Selects the entire row
Ctrl + Shift + Left Arrow: Selects all cells to the left of the active one
Ctrl + Shift + Right Arrow: Selects all cells to the right of the active one
Ctrl + (: Unhides any hidden rows within the selection
Ctrl + ): Unhides any hidden columns within the selection
Ctrl + &: Applies the outline border to the selected cells
Ctrl + _: Removes the outline border from the selected cells
Ctrl + ~: Applies the General number format
Ctrl + $: Applies the Currency format with two decimal places (negative numbers in parentheses)
Ctrl + %: Applies the Percentage format with no decimal places
Ctrl + ^: Applies the Exponential number format with two decimal places
Ctrl + #: Applies the Date format with the day, month, and year
Ctrl + @: Applies the Time format with the hour and minute, and AM or PM
Ctrl + !: Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values
Ctrl + -: Displays the Delete dialog box to delete the selected cells.
Ctrl + *: Selects the current region around the active cell (the data area enclosed by blank rows and blank columns)