• Toggle between formulas and values: CTRL-~
• Name a cell (or range): CTRL-F3, or ALT-I-N-D
• Quickly highlight a range: Shift,End,Arrow,End,Arrow
• The other day I showed how to add items to a database. This worked, but the new items were not included in the named range (so you'd have to go back and change that). Mike Heaton says that they will only be added automatically if that named range is called "database".