If you need to enter the same data into multiple cells in Excel, it’s easy with this simple trick.

1. Select the cells where you need to enter the data.  If the cells are not contiguous,  use the CTRL key to select.
2. Type the data you want into the last cell you select.
3. Press CTRL + ENTER.
4. Excel will enter the same data into every selected cell.