How to Make Columns the Same Size in Google Sheets [Guide]

Keeping your spreadsheet neat and organized is an important part of working in Google Sheets. When column widths are inconsistent, your worksheet can look cluttered, making it difficult to read data or present information professionally. Whether you are creating a budget, attendance sheet, sales report, inventory list, or project tracker, having columns that are the same size improves readability and gives your spreadsheet a clean appearance.

Fortunately, Google Sheets makes it easy to resize multiple columns so they all have the same width. You can manually set an exact width, use the resize option, or adjust several columns at once with just a few clicks. These methods work whether you have two columns or hundreds of columns in your worksheet.

In this guide, I have explained everything in detail!

Table of Contents

How to Make Columns the Same Size in Google Sheets

Making columns the same size simply means assigning the same column width to multiple columns. Instead of adjusting each column one by one, you can select all the columns you want to resize and apply a single width value. This saves time and creates a consistent layout across your spreadsheet.

Follow the steps below to resize multiple columns with ease.

Step 1: Open Your Google Sheets Spreadsheet

The first step is to open the spreadsheet where you want to make the columns the same size.

Open your web browser and visit Google Sheets. Sign in with your Google account if you are not already logged in. From the Google Sheets homepage, open an existing spreadsheet or create a new blank spreadsheet by selecting the Blank option.

Once your spreadsheet opens, take a moment to identify the columns you want to resize. Every column is labeled with letters such as A, B, C, and so on. These column letters are located across the top of the worksheet.

If your spreadsheet contains many columns, scroll horizontally until you find the section you want to edit. Understanding where your columns are located will make the resizing process much easier.

Step 2: Select All the Columns You Want to Resize

Before changing the width, you must select the columns that should have the same size.

Click the letter at the top of the first column you want to resize. Next, press and hold the Shift key on your keyboard. While holding the key, click the letter of the last column you want to include. Google Sheets will highlight every column between the first and last selection.

If the columns are not next to each other, hold the Ctrl key on Windows or the Command key on Mac while clicking individual column letters.

You can also select every column in the worksheet by clicking the blank square located in the upper left corner where the row numbers and column letters meet. This is useful when you want every column in the spreadsheet to have the same width.

Taking a few seconds to select the correct columns ensures that all of them will receive the same width during the next step.

Step 3: Open the Resize Columns Menu

After selecting your columns, you need to open the resizing options.

Move your mouse pointer over one of the highlighted column letters. Right-click the selected area to open the shortcut menu. From the menu, click Resize columns.

A small dialog box will appear on your screen. This window allows you to specify exactly how wide the selected columns should be.

You will usually see two choices. One option lets you enter a specific column width measured in pixels. The other option allows Google Sheets to fit the column width automatically based on the data inside the columns.

Since the goal is to make every selected column the same size, choosing a specific width is usually the best option.

Step 4: Enter the Same Column Width

Inside the resize dialog box, select the option that allows you to specify a column width.

Type the width you want into the text box. The value is measured in pixels. For example, entering 120 makes every selected column 120 pixels wide.

If you are unsure which width to use, think about the type of information stored in the spreadsheet. Columns containing short names may only need a smaller width, while columns containing longer text may require a larger value.

After entering the desired width, click OK.

Google Sheets immediately changes every selected column to the exact same size. Because all columns share the same width, your worksheet now has a more balanced and professional appearance.

Step 5: Check the Results and Make Adjustments if Needed

After resizing the columns, spend a moment reviewing your spreadsheet.

Scroll through the worksheet and verify that all selected columns now have identical widths. If some text appears cut off or difficult to read, you can repeat the resizing process using a slightly larger width.

If the columns appear too wide and there is unnecessary empty space, simply reduce the width by repeating the same steps with a smaller pixel value.

Remember that resizing columns does not change the information stored inside the cells. It only changes how much horizontal space is available for displaying the content.

Making small adjustments after reviewing the worksheet helps you achieve the best possible layout.

Step 6: Use Dragging for Quick Equal Sizing When Appropriate

There may be situations where you only have a few columns to resize.

After selecting multiple columns, you can drag the border between two selected column headers. Google Sheets applies the same adjustment to every selected column at the same time.

This method is useful when you prefer visual adjustments instead of entering an exact pixel value. As you drag the border, watch how the columns change size together.

Although dragging is convenient, entering a specific pixel width is usually more accurate, especially when you want a consistent layout across multiple worksheets.

Step 7: Save and Continue Working

One of the advantages of Google Sheets is that it automatically saves your changes.

After resizing your columns, there is no need to click the Save button. Your updated spreadsheet is automatically stored in your Google Drive.

You can continue entering data, formatting cells, sharing the spreadsheet with others, or printing it without worrying about losing your changes.

If you share the spreadsheet with coworkers or classmates, they will also see the updated column widths when they open the file.

Tips for Choosing the Right Column Width

Choosing the correct column width depends on the type of data in your spreadsheet.

If your worksheet mainly contains numbers, smaller column widths often work well because numbers usually take up less space.

For spreadsheets containing names, addresses, or descriptions, wider columns improve readability and reduce the need for wrapped text.

If you regularly create spreadsheets with similar layouts, using the same column width across different worksheets creates a more consistent and professional look.

Remember that there is no single perfect width for every spreadsheet. The ideal size depends on your content and how you plan to use the worksheet.

FAQs

Can I make all columns the same size at once?

Yes. Select every column in the worksheet by clicking the blank square in the upper left corner, then use the Resize columns option to enter a single width value.

What unit does Google Sheets use for column width?

Google Sheets measures column width in pixels. Entering a pixel value allows you to assign the same width to every selected column.

Will resizing columns change my data?

No. Resizing only changes the display width of the columns. Your data remains exactly the same.

Can I automatically resize columns based on the data?

Yes. In the Resize columns dialog, you can choose the option to fit the data automatically. However, if different columns contain different amounts of text, they may end up with different widths.

Can I resize non-adjacent columns together?

Yes. Hold the Ctrl key on Windows or the Command key on Mac while selecting individual columns, then resize them together.

Why are some words still hidden after resizing?

If the selected width is too small, longer text may still not fit completely. Increase the column width or enable text wrapping to display the full content.