To wrap text in Google Sheets on an iPad, select the cell or cells, tap the Format icon, open the Cell tab, and choose Wrap under Text wrapping. This displays long cell contents on multiple lines instead of letting them spill across empty cells or appear cut off. The steps below are for the Google Sheets iPad app; a browser alternative is included if you are using Sheets in Safari.
What You’ll Need
- An iPad with the Google Sheets app installed, or a browser that can open your Google Sheets file.
- Access to the spreadsheet with permission to edit its formatting. If you only have view access, you may need to request editing permission or make an editable copy.
- A cell, range, row, or column whose text you want to display on multiple lines. You do not need to change the column width first.
Step-by-Step
- Open the spreadsheet in the Sheets app. Launch Google Sheets, open the file, and navigate to the sheet with the text you want to wrap. If the file opens in view-only mode, check whether you can switch to editing or create a copy you can edit. Wrapping changes the cell’s display, not the words stored in it.
- Select the cells to format. Tap a cell to wrap just that cell. To select a neighboring range, tap the first cell and use the blue selection handles to extend the highlight over the other cells. You can also tap a column letter to select a whole column, or a row number to select a whole row. If you select more than one cell, the Wrap setting applies to the entire selected area.
- Open the formatting controls. Tap the Format icon in the toolbar. It is usually shown as an A with horizontal lines beside or below it. A formatting panel should appear, with tabs such as Text and Cell. If the panel is open but you cannot see the controls, make sure the Cell tab is selected rather than Text.
- Find Text wrapping. In the Cell tab, scroll through the cell options until you find the Text wrapping section. Depending on the app version and screen layout, it may be lower in the panel, so swipe within the panel to reveal more settings. The wrapping choices are commonly represented by icons for overflow, wrap, and clip.
- Choose Wrap. Tap the Wrap option. The text in each selected cell should now break onto additional lines when it reaches the cell’s edge. Close the formatting panel by tapping the Format icon again or tapping outside the panel, then check the selected cells on the sheet.
- Check the row height and column width. Wrapping generally allows the row to grow taller so the wrapped lines are visible, while keeping the column width as it is. If the row is still too short or the text looks crowded, widen the column slightly or adjust the row height. A modest width increase can reduce the number of lines without undoing wrapping.
- Apply the setting to other cells if needed. Select another range and repeat the same Format icon > Cell > Text wrapping > Wrap steps. If several adjacent columns need the setting, select them together by their column letters before choosing Wrap. Check the result, especially if the selected cells contain a mixture of long and short entries.
Using Sheets in a browser on iPad: If you have opened the desktop Sheets interface in a browser and its menus are available, select the cells, then use Format > Wrapping > Wrap. A mobile browser may instead show a simplified interface or open the Sheets app. The app steps above are usually the more direct option on an iPad.
Common Mistakes
- Opening the Text tab instead of Cell. The Text tab contains font and style options, such as bold and text color. Wrapping is a cell setting, so look in the Cell tab of the formatting panel.
- Selecting only one cell by accident. If you intended to format a whole column or range, confirm that the blue selection covers all of it before tapping Wrap. Otherwise, only the active cell changes.
- Expecting the column to become wider. Wrap keeps the text within the existing column width; it does not automatically widen the column. The usual change is that the row becomes taller to show extra lines.
- Confusing Wrap with Clip or Overflow. Clip hides text that does not fit in the cell. Overflow can display it in neighboring empty cells. Wrap places the content on multiple lines inside its own cell.
- Assuming wrapping edits the cell’s contents. It does not insert line breaks into the stored text. It changes how Sheets displays the text, so copying the cell’s value elsewhere does not necessarily carry over the same visual layout.
Tips
- Use wrapping for labels and notes. Long headings, addresses, descriptions, and comments are good candidates when you want the full entry visible without making a column extremely wide.
- Format a whole column for consistent entry. If a column will regularly contain long descriptions, select the column letter and choose Wrap once. New entries in that formatted column can use the same display setting.
- Balance width and height. A very narrow column can turn a short sentence into many lines and make the sheet difficult to scan. Widening it a little can make wrapped text easier to read while keeping other columns in view.
- Use landscape orientation when reviewing wide sheets. Rotating the iPad can show more columns at once. This does not change the cell formatting, but it can help you inspect the wrapped result without repeatedly scrolling sideways.
- Remember that wrapping is formatting, not content cleanup. If a cell contains accidental spaces or unwanted line breaks, wrapping will not remove them. Edit the cell’s text separately if the content itself needs correction.
- Check the print or export result separately. The sheet may fit differently on a printed page or in a PDF than it does on the iPad screen. Preview the output and adjust column widths, row heights, or print scaling if any lines are hidden there.
Troubleshooting
- The words still appear cut off. Reopen the Format panel, confirm that the intended cells are selected, and verify that Wrap—not Clip or Overflow—is active. Check that you used the Cell tab. If the setting is correct, tap another cell and return to see whether the sheet display refreshes.
- The row does not show every line. Tap the cell and check whether it is merged with other cells. Merged cells can behave differently from ordinary cells when their row height needs to adjust. If possible, unmerge the cells and try wrapping again. If the row has a manually set height, increase it using the row controls, or open the file in desktop Sheets and adjust the row there.
- The text wraps, but the row becomes too tall. This often happens when the column is narrow or the entry is long. Widen the column, shorten the text if appropriate, or use a brief label in the cell and put the longer explanation elsewhere. Wrap does not reduce font size automatically.
- You cannot find the Format icon or Cell tab. Check that the file is open in the Google Sheets app and not merely in a preview screen. Tap the pencil or editing control if the file is in viewing mode. App layouts can shift after updates; look for the A-and-lines formatting control and then the Cell tab.
- Nothing changes after you tap Wrap. Confirm that the spreadsheet is editable and that the selected cell actually contains enough text to need another line. A short value may look unchanged because it already fits. If you are in Safari, try the Sheets app or use the browser’s desktop site and the Format > Wrapping > Wrap menu path.
- Only some of the selected cells change. Review the selection before applying the setting. If cells are on different parts of the sheet or the selection was not extended as intended, apply Wrap to each needed range separately. Also check whether you selected entire rows or columns when you meant to select only a small block.
Frequently Asked Questions
Does wrapping change the text in a cell?
No. Wrapping changes the way Sheets displays the existing content. It does not rewrite the value or add manual line breaks. To edit the actual words, tap the cell and edit its contents separately.
Will Google Sheets automatically make the row taller?
Usually, Sheets adjusts the row to show the wrapped lines. A manually fixed row height or merged cells can prevent the full text from appearing, so increase the row height or review the merged-cell layout if text remains hidden.
Can I wrap text in an entire column on iPad?
Yes. Tap the column letter to select the column, open Format, choose the Cell tab, and set Text wrapping to Wrap. Check the selection first, since choosing a column applies the setting to all its cells, not just the visible ones.
What is the difference between Wrap, Clip, and Overflow?
Wrap displays the content on multiple lines within the cell. Clip hides the portion that does not fit. Overflow lets text extend into neighboring empty cells. Choose Wrap when the full text should remain visible without crossing into the next cell.
Can I wrap text in Google Sheets using Safari on iPad?
It depends on how Sheets opens in the browser. If the desktop Sheets menus are available, select the cells and use Format > Wrapping > Wrap. If the browser gives you a limited mobile view, open the spreadsheet in the Google Sheets app and use the Cell tab instead.
Does wrapping work the same way in Excel?
The goal is similar, but the controls differ. In Excel for Microsoft 365, select cells and choose Home > Wrap Text. The Google Sheets app uses its Format panel, while Google Sheets in a desktop browser has the Format > Wrapping > Wrap menu.
Related
- Clear Cache in Microsoft Outlook: Windows, Mac & Web
- How to Clear Cache Files in Outlook Safely
- Clear Cache and Cookies in Outlook: Step-by-Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add Reference Citations in Word, Step by StepTo add a reference citation in Microsoft Word, open the References tab, choose a citation style, then select…
- Word Styles: How They Work and When to Use ThemMicrosoft Word styles are saved sets of formatting that you can apply to text or paragraphs, such as…
- SUMIF Negative Values in Google Sheets: ExamplesIf your values are in A2:A7, enter =SUMIF(A2:A7,"<0") to add only the negative numbers; for example, -12, 8,…
- Can Google Sheets Freeze Rows Based on Cell Values?No—Google Sheets cannot natively freeze or unfreeze rows automatically according to a cell’s value. You can freeze a…
- Excel Heat Maps: Create, Format, and Read Color ScalesIn Excel, a heat map is usually a range of cells colored by value using Conditional Formatting. Select…
- Customize Styles in Word: A Practical Step-by-Step GuideTo customize styles in Microsoft Word, open the Home tab, right-click a style in the Styles gallery, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.