How to make text fill a cell instead of spilling over

By default, Google Sheets lets text spill into the next cell if it is too long to fit. You can make text stay inside one cell and fill it completely in three ways: wrap the text so it breaks into multiple lines, shrink the text size to fit, or use a combination of both. Each method works differently depending on whether you want to keep your text readable or prioritize fitting everything in one cell.

The most common choice is text wrapping, which breaks long text into multiple lines within a single cell. This keeps your text at full size and readable. The second option is shrink to fit, which automatically reduces the font size until the text fits on one line. The third is to combine both: wrap the text and let it shrink if needed.

Key Takeaways

  • Text wrapping breaks long text into multiple lines within the same cell and is the most readable option for most spreadsheets.
  • Shrink to fit reduces the font size automatically so text fits on one line, useful when you want to keep row height consistent.
  • You can explore these settings to a single cell, a range of cells, or an entire column at once.
  • Wrapped text increases row height automatically, while shrink to fit keeps rows the same height but makes text smaller.

How to wrap text in a cell

Select the cell or cells where you want text to wrap. Click the cell, then hold Shift and click another cell to select a range, or click the column letter to select an entire column. You can also click and drag to highlight multiple cells at once.

Once your cells are selected, go to the Format menu at the top and click Text wrapping. A submenu will appear with three options: Overflow (the default, which lets text spill over), Wrap (which breaks text into multiple lines), and Clip (which hides text that does not fit). Click Wrap.

Google Sheets will automatically increase the row height to fit all the wrapped text. If you type or paste new text into that cell later, the row will adjust again. This is the easiest way to keep all your text visible without changing font size.

How to shrink text to fit a cell

Select the cell or cells you want to adjust. Go to Format and click Text wrapping, then select Shrink to fit.

Google Sheets will reduce the font size automatically so the text fits on a single line within the cell. The row height stays the same. This is useful when you have a spreadsheet with many columns and want to keep rows short, or when you are comparing data side by side and need consistent row heights.

One drawback: if you add more text to that cell later, the font will shrink further. Very long text can become hard to read. If readability matters more than row height, text wrapping is usually the better choice.

Combining wrap and shrink for maximum control

You can also use wrap and shrink together. Select your cells, go to Format and Text wrapping, then choose Wrap. Then select the same cells again, go back to Format, and this time click Alignment. Under the alignment options, you will see a checkbox for Shrink to fit. Check that box.

Now text will wrap into multiple lines, but if it still does not fit, the font size will shrink as well. This gives you the most flexibility: text stays readable as long as possible, but the row height does not grow infinitely if you paste a very long block of text.

Adjusting row height manually

If you have wrapped text but the row is not tall enough to show all of it, you can increase the row height by hand. Move your cursor to the line between two row numbers on the left side of the spreadsheet. The cursor will change to a resize arrow. Click and drag down to make the row taller.

You can also right-click the row number and select Resize row, then type a specific height in pixels. This is useful if you want all rows to be exactly the same height, even if they contain different amounts of text.

Undoing text fill settings

To remove wrapping or shrink settings and return to the default overflow behavior, select the cells, go to Format and Text wrapping, then click Overflow.

If you have already adjusted row height manually and want to reset it, right-click the row number and select Resize row. Click Optimal height and Google Sheets will automatically set the row to fit the content with your current text wrapping settings.

When to use each method

Use wrap when you have a spreadsheet people will read on screen or print, and you want all text visible and readable. Headers, notes, and descriptions are good candidates for wrapping.

Use shrink to fit when you have many columns and limited space, or when you are comparing numbers or short labels side by side. Financial reports and inventory lists often use shrink to fit to keep the view compact.

Use wrap plus shrink when you are not sure how much text will end up in a cell, or when you want a balance between readability and consistent row height. This is the safest choice for shared spreadsheets where different people add content.

Frequently Asked Questions

Does wrapping text change the actual content of the cell?

No. Wrapping only changes how the text is displayed. The cell still contains the same text; it just breaks into multiple lines visually. If you copy the cell, paste it elsewhere, or export the spreadsheet, the text remains unchanged.

What happens if I wrap text and then delete some of it?

The row height will shrink automatically to fit the remaining text. Google Sheets adjusts row height dynamically when text wrapping is on, so you do not have to resize manually.

Can I wrap text in only part of a cell?

No. Wrapping applies to the entire cell. If you want to format only part of the text differently, you would need to split the content into separate cells or use a different approach like bold or color formatting.

Does shrink to fit work with very long text?

Yes, but the text may become too small to read comfortably. If you have very long text and use shrink to fit, test it first to make sure the final size is still readable. Wrapping is usually better for longer content.

Can I set text wrapping as the default for new cells?

Not for the entire spreadsheet at once. You can select all cells (Ctrl+A or Cmd+A), explore wrapping, and then all new cells you create will inherit that formatting. However, this affects the whole sheet, so use it only if wrapping is your standard for that spreadsheet.