Arrow left
Back to product guides
Google Sheets Tips

How to Resize Column Width in Google Sheets

In this article, you will learn how to modify column width in Google Sheets. Changing column width helps you make your table or list look beautiful, organized, and straightforward. There are a few ways to adjust column width, so you need to select the most suitable method for your purpose.

How to adjust column width in Google Sheets

Using a mouse cursor

  1. Put your mouse cursor between the column index of a column whose width you want to change and that of the next column to the right.
  2. When you see the “↔️” mark, click there, drag it until full cell content shows up, and release it.
  3. The column’s size changes
How to change column width with your mouse cursor in Google Sheets

This method is effective when you want to change a single column width. If you need to modify a couple of or more columns’ widths, you are recommended to take one of the following approaches.

Using a mouse cursor and a double-click

  1. Select the column index whose size you want to adjust.
  2. Put your mouse cursor between one of two adjacent indexes in the selected range.
  3. When you see the “↔️” mark, double-click the mark.
  4. The columns’ sizes in the range are automatically adjusted to show their content fully.
How to change the sizes of multiple columns simultaneously in Google Sheets

This method is better than the first one because you can adjust multiple columns simultaneously. As this option makes the column size fit values in cells, some column sizes shrink depending on their data volume. There is another way to get the same effect, which is described below. As a result, you may see the various sizes of cells on your worksheet, though the values in cells can be visible clearly.

Using a column width menu - 1

  1. Select the column indexes whose size you want to adjust.
  2. Right-click on the chosen range.
  3. Select “Resize columns X-Y”, which brings up a pop-up. (In the example below, it says, “Resize columns B-D. This assumption is the same for the other example in this article.)
  4. Choose “Fit to data” in the pop-up.
  5. The sizes of the selected columns are adjusted to show their values fully.
How to modify column width by right-clicking in Google Sheets

What a pop-up for column width adjustment menu looks like in Google Sheets

Using a column width menu - 2

  1. Select the column indexes whose size you want to adjust.
  2. Right-click on the chosen range.
  3. Select “Resize columns X-Y”, which brings up a pop-up.
  4. Choose “Specify column width” and input a specific column size in the pop-up (on a pixel basis).
  5. Click the “OK” button.
What a pop-up for column size adjustment menu looks like in Google Sheets

We introduced four ways to resize the column size. Again, it is important to pick up the most suitable options for your purpose (e.g., getting values in all cells completely visible or setting the same column width for all columns).

How do you autofit row width in Google Sheets?

Check this article to learn how to modify row height in Google Sheets.

Is there another way to show a value in a cell properly?

You can consider wrapping text. Check this article to learn how to use it.

Analyze your live financial data in a snap

Are you learning this tip to build a financial KPI dashboard or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711