Final answer:
To copy and paste text into multiple cells in Excel, copy the cell with Ctrl+C, then select the destination cells and paste with Ctrl+V. For exact copying of text or formulas, use the Paste Special feature after pasting.
Step-by-step explanation:
To copy and paste text into multiple cells in Excel, first you need to copy the text or cell that you want to duplicate. To do this, select the cell with the text and press Ctrl+C on your keyboard. Next, select the range of cells where you want to paste this text and press Ctrl+V. Excel will paste the copied text into each of the cells you've selected. If you're copying a formula, Excel will automatically adjust any cell references relative to the position where you paste it.
If you wish to paste the exact same text or formula without adjusting references (copy absolute), after pressing Ctrl+V, you will need to use the Paste Special feature. Access this by clicking on the lower part of the Paste button on the Home tab and selecting 'Paste Special'. Then, choose 'Values' or 'Formulas', depending on what you need.