Fill a Selected Range with the Same Data

Need to enter the same data in a range of cells? Here’s how:

  1. Select a range of cells.
  2. Type in some data.
  3. Use the fill function in Microsoft Office Excel—press CTRL+ENTER, and the range selected will be filled with the same data.