Product Version – All Version of Microsoft Excel
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. C100.
3. Now Press Shift + Enter to select all the cells from A1:C100.
4. Now you can press enter to copy the initial content to all cells.
Click Cell A1 -> Ctrl C -> Click Name Box -> Select Cell C100 -> Shift Enter -> Enter