This will bring up the Find and Replace dialog box with the Replace Tab already active So if we want to find and place out line breaks with a space.
You can search for line breaks using this shortcut instead. So, instead of the ALT+Enter shortcut we need to enter CTRL+J, this is the shortcut to the line break which is character 10 in the ASCII control code.
Normally if you want to find and replace some text then you would just hit the CTRL+F shortcut to bring up Find and Replace dialog box.īut, if you enter ALT+Enter in Find What, nothing happens apart form your computer beeping at you- not allowed!.
It is though, slightly harder to remove them if you need to. I know that I normally use them to make text easier to read in cells, longer pieces of text or bullet points for example. It is really easy to insert line breaks into Excel cells, all you need to do is hit ALT+ENTER where ever you want one.
