Excel 2007: Enter the Same Value

You can enter the same value into multiple cells simultaneously. Even though this is a tip that has been around for a while, it's worth mentioning again. I'm all about saving time and this is great!

1. Select all the cells into which you want to enter the value.
2. Type the value in the active cell of your selection.
3. Press CTRL+ENTER