Home » How-To » How to Fit Text in Google Sheets

How to Fit Text in Google Sheets

When you type some text in a cell in Google Sheets, it will not automatically fit in it.

Instead, the text will go out of the cell and overflow to the next column(s).

Unfortunately, there isn’t a shortcut for fitting/keeping text into a cell.

Hence, you need to manually wrap the text to prevent it from overflowing.

To fit text in Google Sheets, you can either wrap the text or resize the columns to fit the data.

Here are two methods to fit text in Google Sheets.

Method 1: Wrap text

Fit text in Google Sheets

How to fit text in Google Sheets by wrapping them:

  1. Select all of the columns/rows (shift + click).
  2. Click “Format” on the top navigation bar.
  3. Select “Wrapping”.
  4. Select “Wrap”.

After you’ve selected “Wrap”, the text in the columns (that you’ve selected) will be wrapped.

Wrapping will fit/keep the text in a cell based on the width of the column.

Hence, the text will not overflow out of the cell.

If you’re writing in a new column, you need to wrap the text in it again.

Method 2: Fit to data

Fit to data in Google Sheets

How to fit text in Google Sheets by fitting them to the data:

  1. Select all of the columns/rows (shift + click).
  2. Right-click a column/row.
  3. Select “Resize columns X – Y”.
  4. Select “Fit to data”.
  5. Click “OK” to save your changes.

After you’ve selected “Fit to data”, all text will fit in all cells.

Similar to wrapping, the text will fit based on the width of each column.

You can edit the size of a column by right-clicking it and clicking on “Resize columns”.

Instead of selecting “Fit to data”, select “Enter new column width in pixels” and enter the width that you want to set for the column(s).

Further reading

How to Center Text in The Middle in Google Docs

How to Remove Table Borders in Google Docs

How to Make Text Vertical in Google Docs

About the author

Lim How Wei

Lim How Wei is the founder of followchain.org, with 8+ years of experience in Social Media Marketing and 4+ years of experience as an active investor in stocks and cryptocurrencies. He has researched, tested, and written hundreds of articles ranging from social media platforms to messaging apps.

Lim has been quoted and referenced by major publications and media companies like WikiHow, Fast Company, HuffPost, Vice, New York Post, The Conversation, and many others. One of his articles about the gig economy was quoted by Joe Rogan who hosts The Joe Rogan Experience (arguably the most popular podcast in the world), in the This Past Weekend podcast by Theo Von.

In his free time, Lim plays multiple games like Tower of Fantasy, League of Legends, Counter-Strike, Hearthstone, RuneScape, and many others. He creates guides, walkthroughs, solutions, and more on games that he plays to help other players with their progression.