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.