Entering Duplicate Text – Adjacent Cells

If you require duplicate data entered into a number of cells that are adjacent to each other – you can do this quickly and easily.

  1. Select the range of cells first. E.g. B2:B5
  2. The first cell selected (B2) is the active cell and is white whilst the others are shaded grey
  3. Type “North” and hold the CTRL key whilst pressing the Enter key
  4. This will enter the word “North” into each of the cells in the selected range.
Fig 1.

Fig 1.

Fig 2.

Fig 2.

Leave a Reply

Your email address will not be published. Required fields are marked *