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.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
Comments
