VOOZH about

URL: https://www.geeksforgeeks.org/how-to-wrap-text-in-google-sheets/

⇱ How to Wrap Text in Google Sheets - GeeksforGeeks


  • Courses
  • Tutorials
  • Interview Prep

How to Wrap Text in Google Sheets

Last Updated : 25 Mar, 2026

Text wrapping in Google Sheets is a feature that controls how text is displayed within a cell when it exceeds the cell's width. It ensures your data is readable and fits well within the spreadsheet layout.

  • Keeps text visible without cutting it off.
  • Maintains neat and organized formatting, especially for longer text entries.
  • Helps prevent overlapping with adjacent cells.

1. Text Wrapping Options

OptionBehaviorExample
WrapAdjusts the row height to display all text within the cell.Text appears on multiple lines.
OverflowText spills into adjacent empty cells if available.Text extends beyond the cell.
ClipCuts off text that doesn’t fit within the cell.Only visible text fits the cell.

2. Wrapping Text in Google Sheets from the Format Menu

To wrap text in Google Sheets using the Format menu, follow these simple steps to ensure your data is displayed neatly and clearly within the cells.

Step 1: Select the Cell(s)

Highlight the cell or range of cells where you want to apply text wrapping.

πŸ‘ How to Wrap Text in Google Sheets
Select the Cells

Step 2: Open the Format Menu

Click on the Format option in the top menu bar to access formatting tools.

πŸ‘ How to Wrap Text in Google Sheets
Open the Format Menu

Step 3: Choose Text Wrapping and Select a Wrapping Option

In the dropdown menu, hover over Text Wrapping to reveal additional options. Choose one of the following:

  • Overflow: Text spills over into adjacent cells (default).
  • Wrap: Text wraps within the cell to fit its width.
  • Clip: Cuts off text that exceeds the cell width.
πŸ‘ How to Wrap Text in Google Sheets
Choose Text Wrapping >> Select a Wrapping Option

Step 4: Text Wrapped

Now you have successfully wrapped your text in Google Sheets.

πŸ‘ How to Wrap Text in Google Sheets
Text Wrapped

3. Wrapping Text in Google Sheets from the Toolbar

To wrap text in Google Sheets using the toolbar, follow these easy steps:

Step 1: Select the Cell(s)

Click on the cell or range of cells where you want to wrap text.

πŸ‘ How to Wrap Text in Google Sheets
Select the CellS

Step 2: Locate the Toolbar and Click on the Text Wrapping Icon

Find the Text Wrapping icon in the toolbar (it looks like a text box with a curved arrow). Click on the icon to open the wrapping options.

πŸ‘ How to Wrap Text in Google Sheets
Locate the Toolbar >> Click on the Text Wrapping Icon

Step 3: Choose the Wrap Option

Select Wrap to make the text automatically fit within the cell and wrap to the next line.

πŸ‘ How to Wrap Text in Google Sheets
Choose the Wrap Option

Step 4: Text Wrapped

Now you have wrapped the selected text using the toolbar.

πŸ‘ How to Wrap Text in Google Sheets
Text Wrapped

4. Shortcut for Wrapping Text in Google Sheets

To wrap text in Google Sheets using a shortcut:

  • Select the Cell(s)
  • Press the Shortcut Key
  • Windows: Alt + O, then W
  • Mac: Option + Command + Z
  • View the Result

5. How to Wrap text in Google Sheets on Mobile

To wrap text in Google Sheets on mobile (Android & iOS), follow these steps:

Step 1: Open the Google Sheets App

Launch the Google Sheets app on your mobile device and open the spreadsheet you want to work with.

Step 2: Select the Cell(s)

Tap on the cell or range of cells where you want to wrap text.

πŸ‘ How to Wrap Text in Google Sheets
Select the Cell

Step 3: Open the Format Menu

Tap the three vertical dots (More options) in the upper-right corner of the screen to access the menu.

πŸ‘ How to Wrap Text in Google Sheets
Open the Format Menu

Step 4: Select the Wrap Option

Choose Wrap to enable text wrapping for the selected cell(s). The text will now automatically wrap within the cell.

πŸ‘ How to Wrap Text in Google Sheets
Choose Text Wrapping

Step 5: Text Wrapped

Now the selected text is wrapped and you can change it different wrap options.

πŸ‘ How to Wrap Text in Google Sheets
Text Wrapped

6. Common Issues with Text Wrapping and How to Fix Them

Here are some frequent problems with text wrapping in Google Sheets and solutions to address them:

IssueCauseSolution
Text Not Wrapping ProperlyText wrapping is not enabled for the cell.Select the cell(s), go to Format > Text Wrapping > Wrap to enable wrapping.
Row Height Doesn’t Adjust AutomaticallyAutomatic row resizing is disabled.Right-click the row, choose Resize Row, or double-click the row boundary for auto-adjustment.
Overflowing Text into Adjacent CellsText wrapping is set to Overflow.Change the wrapping option to Wrap or Clip under Format > Text Wrapping.
Text Clipped Within CellWrapping is set to Clip instead of Wrap.Update the wrapping setting to Wrap under Format > Text Wrapping.
Misaligned Text After WrappingDefault alignment causes text placement issues.Align the text using the alignment options under the Toolbar (e.g., Center, Left).

By addressing these issues, you can ensure your text is displayed cleanly and efficiently in Google Sheets.


Also Read:

Comment