You may also be interested in my earlier post Input special characters in Excel by pressing Alt + Numpad Try explore different Alt+Number combination and pick the bullet you like. You don’t have to use this round bullet as your bullets. However you cannot do that in the Find and Replace, where you need “ Ctrl+J” instead to insert a line break.Īlt+7 (on the numpad) is the easiest way to insert the round bullet In a regular cell, if you want to insert a line break, you need to press Alt+Enter.
(note: you may notice nothing, but at a closer look you will see a tiny blinking dot at the bottom of the input box)
Ctrl+H to open the Find and Replace dialogue box Select the range where you need to add bullet to the beginning of each new lineĢ. What is not so clear to you is what I input in the dialogue box for “Find what” and “Replace with:”. The trick is about Find and Replace, obviously. (Supposed you have input each new line by using Alt+Enter) Luckily enough, there is a workaround trick for this task. If you have experienced the task shown above, you should know how tedious and time-consuming it could be as you cannot convert each line into bullet point by clicking one button as if in Word or PowerPoint. Does it sound familiar to you? Are you using Excel as word processing tool?
