Description

Enter data in: A single cell, A range of cells, All cells on a worksheet, Nonadjacent cells or cell ranges, An entire row or column, Adjacent rows or columns, Nonadjacent rows or columns In the active cell, type the data, and then press CTRL+ENTER.

Excel - How to enter the same data into several cells at the same time
From: helpvids