![]() ![]() 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. Hold Alt key and press 7(on numpad of your keyboard) and then releaseĢ.3 Click Replace All Explanation of the actionsĬtrl+J is the way to input line break in Find and Replace.(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? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |