1. Select Numerous cells (to which you need to copy same cell content)
2. Type the text/value (that you wish to copy)
3. Press CTRL + ENTER
1. Select the desired cell and copy its contents.
2. In the Name box enter the last cell that you would like to copy too e.g. D50.
3. Now Press SHIFT + ENTER to select all the cells from A1:D50.
4. Now you can Press ENTER to copy the initial content to all cells.
Key Sequence: Click Cell A1 -> CTRL + C -> Click Name Box -> SHIFT + Select Cell D50 -> ENTER