You may encounter instances in which you need to enter the same info in multiple cells in a spreadsheet. You can do that quickly and simply with the following steps.
1. In an Excel spreadsheet, click the entire set of cells in which you want to enter the common data. This is done by dragging your cursor or by holding the CTRL key as you click each one.
2. In the last cell selected, type the information that is needed for the cell.
3. Hit CTRL + Enter to have the information appear in all the selected cells.
This information can also be found at SharePoint > Software Users Groups > Excel > Multiple Cells Same Data.docx.