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.
If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas at 472-0585 or rmaltas2@unl.edu.
