How To Make All Columns The Same Width In Google Sheets

Last Updated on October 30, 2023 by Jake Sheridan

In this tutorial, you will learn how to make all columns the same width in google sheets.

When a Google Sheet goes through many iterations or is edited by different people, it can end up with a lot of inconsistencies in its formatting and layout. One inconsistency that can make it hard to quickly scan data is random variation in column width. Fortunately, it’s quick and easy to make all the columns in a sheet the same width. Just follow these steps:

Step 1

The first step is to select all the columns to resize them. If you have a lot of columns in the sheet, manually selecting all of them can be time consuming, but we can use the name box beside the formula bar to select all the columns at once. Simply click on the name box and type in the full column range you want to resize. In this example, the last column is column Z, so the range is A:Z, but if you’ve added or removed columns you may need to scroll to the end of your spreadsheet and see what the last column letter is, then input the range from column A to the last column

Step 2

After selecting all the columns, right-click anywhere on the column headers and choose Resize Columns from the menu

Step 3

In the Resize Column popup, enter the new column width in pixels then click OK