Q. I'm trying to paste a bullet list from Word into a single cell in Excel, but when I do, my paste job spans multiple rows. Is there an easy way to paste a long bullet list into a single cell?
A. To paste a bullet list from Word into a single cell in Excel, copy the bullet list in Word, toggle to Excel, select the desired cell, press the F2 key to invoke edit mode, and then paste, as suggested by the screenshots below. The bullet list will paste into a single Excel cell.
About the author
J. Carlton Collins, CPA, (firstname.lastname@example.org) is a technology consultant, a conference presenter, and a JofA contributing editor.
Submit a question
Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to email@example.com. We regret being unable to individually answer all submitted questions.