Wednesday, September 26, 2012

Excel Keyboard Shortcuts

I use Excel on occasion for data entry, but not enough to really get familiar with the shortcuts. Here are a few that are worth knowing:

F2 Edit the current cell. If you want to overtype, just start typing instead of pressing F2
Ctrl+; Enter today’s date – super handy if you are updating some kind of daily log
= Not a shortcut in the same way, but = tells Excel that the rest of the cell value is a formula, so you can just type a formula and skip the formula editing dialog.
TODO: Cell and cell range format  

No comments: