Tip of the Day - Excel 2007: Quickly Replicate Cells
Fill a Selected Range with the Same Data
Need to enter the same data in a range of cells? Here’s how:
- Select a range of cells.
- Type in some data.
- Use the fill function in Microsoft Office Excel—press CTRL+ENTER, and the range selected will be filled with the same data.