Enter a carriage return in excel for mac

broken image
broken image

Excel won’t let you put that shortcut into the Find What box. However, if you try to type Alt + Enter in the Find What box, you’ll just hear a beep from your computer. To find specific text in Excel, you can use Ctrl + F to open the Find and Replace dialog box. Line breaks are easy to add, but a little trickier to remove. But how can you find and replace line breaks in Excel?

broken image

You can put one or more line breaks in a cell, to make the contents easier to read. When you want to create a line break (line feed) in a cell, you press Alt + Enter, to start a new line.