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

More ways to use columns in Google Sheets:
- Move A Column
- Add A Column
- Set Column Width
- Delete Columns
- Rename A Column
- Compare Two Columns
- Add Multiple Columns
- Apply A Formula To An Entire Column
- Sort Multiple Columns
- Auto Fit Column Width
- Group Columns
- How To Name Columns
- Sum A Column
- Sort By Column
- Lock Column
- Split Text into Columns
- Apply Formula To Entire Column
- Combine Columns
- Find Unique Values In Column
- Move Columns
- Filter Columns
- Filter Multiple Columns
- Split A Column
- Get the Last Value in a Column
- Convert Rows To Columns
- Multiply Columns
- Highlight Duplicates In Multiple Columns
- Switch Columns
- Select Multiple Columns
- Subtract Columns
- Number A Column