Go to the next line in excel 2016 for mac in the same cell

broken image
broken image

Text flows outside cell boundary when the next cell is empty (row 1). If there’s only one cell in the column with longer text, it’s a waste of space for the rest of the column or it’ll mess up the formatting for the rest of the worksheet. Sure, you can drag the edge of the column to make it bigger, but you can only do that so much before you start running out of room for your other columns. Here’s your choices for wrapping text, adding line breaks and merging cells.Īt first, when you type text in a cell it just keeps going across the next cell, if it’s empty. There are plenty of options to fit text in Excel but not all of them are obvious.

broken image

Thanks for joining us! You'll get a welcome message in a few moments.