How to☝️ Make All Columns The Same Width In Google Sheets

To make all columns the same width in Google Sheets, click the Select All box and drag any column header separator to increase or decrease the width of the columns across the entire spreadsheet.

In this guide, we’re going to walk you through the process step-by-step with in-depth instructions.

The Quickest Way to Apply the Same Width to All Columns

Let’s start off with the easiest way to get the job done. Actually, it takes only two simple steps to uniformly change the width of all columns.

  1. Click on the Select All box at the top left corner of your spreadsheet to highlight all cells.

The Quickest Way to Apply the Same Width to All Columns

2. Drag any column separator to adjust cell width for all the selected columns in one fell swoop.

Column separator

As a result, we have all of our columns stretched out the same way. Alternatively, you can use this approach to reduce the width of all columns at once.

The Data

How To Set All Google Sheets Columns the Same Width in Pixels

If you’re looking for a more granular approach, there’s a way to specify the number of pixels and apply that value across all columns in your spreadsheet. Here’s how:

  1. Select Column A, hold down the Shift key, and select Column Z to highlight all columns in your spreadsheet.
  2. Right-click anywhere on the sheet to pull up the contextual menu.
  3. Select “Resize columns A – Z.”

How To Set All Google Sheets Columns the Same Width in Pixels

  1. When the dialog box pops up, under “Enter new column width in pixels. (Default: 100),” set the new width for all the columns in your Google Sheet.
  2. Click “OK” to apply the changes.

Resize columns A - Z

And that’s how you do it. You’ve just successfully set all of your columns to be 200 pixels wide.

The Table in Google Sheets

This simple trick allows you to distribute columns evenly in Google Sheets across your entire spreadsheet in just a few clicks.

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X