If you have the same data that you need to enter into several cells that are not next to each other, there is no need to enter it in manually or use copy and paste. Simply select the noncontiguous cells and use Ctrl + Enter to fill the cells with your data.
To enter data all at once into noncontiguous cells:
- Hold down the Ctrl key and select all of the cells into which you want to enter data (Holding down the Ctrl key allows you to select noncontiguous cells).
- Type your data.
- Press the Ctrl + Enter keystroke combination. Excel will enter the data you typed into all of the cells you selected.