So how to tackle that? Here comes another formatting trick As you see the action performed did not take care of the first line in cell because the beginning of first line is not a result of a line break. We instructed Excel to Find all line break in the selection then replace it with a line bread AND a round bullet. Having understood what Ctrl+J and Alt+7 does, it’s easy to understand what we did in the Find and Replace dialogue box.
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.
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?
0 kommentar(er)
