Many users prefer to accomplish as much as possible by using the keyboard, instead of the mouse (I happen to be such a user). Below are a few helpful shortcut keys to get things done in Excel without having to leave your keyboard:
Number Formatting
- Ctrl+ Shift+ 1 Format the current cell with commas
- Ctrl+ Shift+ 4 Format the current cell as currency
- Ctrl+ Shift+ 5 Format the current cell as a percentage
Deleting/Inserting
- Ctrl+ - Delete the current cell or selection
- Ctrl+ Shift+ + Insert cell or selection
- Ctrl+ ; Insert current date at the selected cell
- Ctrl+ Shift+ ; Insert current time at the selected cell
- Ctrl+ K Insert a hyperlink or web link
Navigation/Selecting
- Ctrl+ Tab Switch to the next worksheet in the workbook
- Shift+ F3 Open the formula window
- Ctrl+F Open the search box
- Ctrl+ Space Select all of the current column
- Shift+ Space Select all of the current row
- Ctrl+ Arrow key Move to the next cell containing data in the direction of the arrow key
- F11 Create a chart
- F3 Set insertion point within cell
Saving
- Ctrl+ S Save workbook
- F12 Save worksheet as template
Similar Posts:
- Editing an Excel 2007 Template
- Inserting a Hyperlink in Excel 2007
- Create a New Template in Excel 2007
- Using Excel 2007’s Extend Mode to Select Cells
- PDF Shortcuts in Leopard
- Insert Rows and Columns in a Word 2007 Table
- Creating & Using Quick Parts in Word 2007
