If you use text in your Numbers sheets, there may have been a time where that text was hidden by the cell to the right. And while you can select the cell and read the text at the bottom in Numbers on Mac, this isn’t always convenient. Plus, this isn’t an option in Numbers on iPhone or iPad.

Here, we’ll show you how to wrap the text in a cell in your spreadsheets. You can apply this formatting to a single cell, group of cells, column, and row. This will increase the height of the cell to display all text within it. But you if you resize the column or row containing the cell, the text will adjust.

Wrap Text Before and After in Numbers

Wrap text in Numbers cells on Mac

Open your workbook in Numbers and select the spreadsheet you want to adjust. Then, follow these steps.

1) Select the cell or group of cells.

2) Open the right-hand sidebar by clicking the Format button on the top right.

3) Choose the Text tab at the top of the sidebar.

4) Check the box for Wrap text in cell.

Wrap Text in Cell in Numbers on Mac

If you want to apply the text wrap to a column, row, or entire table, follow the same steps. But you’ll notice the checkbox has changed to a minus sign. Just click the minus sign to convert it to a checkbox to apply the text wrapping.

Wrap Text in Cell Minus Sign in Numbers on Mac

Wrap text in Numbers cells on iPhone and iPad

Open the spreadsheet in Numbers on iPhone or iPad that you want to work with and do the following.

1) Select the cell, group of cells, column, row, or entire table.

2) Tap the Format icon (paintbrush) at the top.

3) Choose the Cell tab.

4) Enable the toggle for Wrap Text in Cell.

Wrap Text in Cell in Numbers on iPad

Wrap Text in Cell in Numbers on iPad

Wrapping it up

There’s no reason to have your text hidden by another cell in Numbers. Use the text wrapping feature to display all text within your cell to ensure you don’t miss any data.

What tips like this do you have to share for working in Numbers? Comment below or ping us on Twitter!