Excel Tip -  Enter the same value in several cells at once

When you need to fill multiple cells with the same entry you may simply copy and paste the value or use Excel's Fill Handle to do the job. However, there's another technique that can at times be more efficient. Simply select all of the cells that you want to fill. Then, type the entry in the active cell and press [Ctrl][Enter]. Excel plugs the entry into all of the cells that were highlighted. Note that you can also use this technique to fill non-contiguous cells -- simply hold down the [Ctrl] key as you select each cell. Also, you can use the technique to enter a formula in multiple cells at once. If your formula contains relative cell references, Excel adjusts each formula to point to the appropriate relative ranges.