If you require duplicate data entered into a number of cells that are adjacent to each other – you can do this quickly and easily.
- Select the range of cells first. E.g. B2:B5
- The first cell selected (B2) is the active cell and is white whilst the others are shaded grey
- Type “North” and hold the CTRL key whilst pressing the Enter key
- This will enter the word “North” into each of the cells in the selected range.