Home » How-To » How to Change Column Width in Google Sheets

How to Change Column Width in Google Sheets

Is your text not fitting in the cells in Google Sheets?

If so, you can change the width of each column.

Increasing the width of a column will allow more text to fit in its cells.

That way, your text will not overflow to the next column(s).

Google Sheets has a feature where you can resize columns.

The feature can be accessed by right-clicking the column(s) that you want to resize.

In this guide, you’ll learn how to adjust, resize, or change the column width in Google Sheets.

How to change column width in Google Sheets

How to change column width in Google Sheets

  • Select the column(s) that you want to resize.
  • Right-click the column(s).
  • Select “Resize column(s)”.
  • Select “Enter a new column width in pixels”.
  • Enter the column width (in pixels) that you want to change (e.g. 200).
  • Select “OK”.

After you’ve selected “OK”, the width(s) of the column(s) will be resized to the pixels that you’ve entered.

The default column width in pixels is 100.

You can increase or decrease it by entering the pixels into the text field.

You can select more than one column by pressing “Shift” on your keyboard.

If you’ve selected more than one column (e.g. columns A to D), you’ll see the “Resize columns A – D” option.

By entering the pixels into the text field, all of the columns that you’ve selected will be resized when you click on “OK”.

If you just want the text to fit into the cells, you can double click the border next to the alphabet of the column.

In other words, the width of the column will be resized to fit the text.

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.