Question: how to copy one cell to multiple rows in excel?
Answer: Highlight all the cells that you want to have the same text. Type the text you want. After typing the text, instead of pressing Enter, press Ctrl+Enter.