Blank spreadsheets in Google Sheets have a default column width of 100 pixels. But as you start adding data to those cells and adjusting their dimensions, you will likely end up with a lot of columns of varying widths. So if you would like to make all of your columns have the same width again, you may be wondering how to accomplish that.
Adjusting the height of your spreadsheet rows or the width of your columns can be a helpful way to make your data easier to read.
But you may be having trouble getting several of your columns to the same width, as manually dragging the column boundaries can result in imprecise sizing.
Fortunately Google Sheets has a way for you to set the size of a column with a pixel width, and that setting can be applied to multiple columns at once.
Our guide below will show you how to select several columns at once, then set a specific pixel width for all of those columns so that they have the same width.
How to Set All Google Sheets Columns to the Same Width
- Open your spreadsheet.
- Click on the first column letter, hold down Shift, then click on the last column letter.
- Right click on a selected cell and choose Resize columns.
- Enter the column width and click OK.
Our guide continues below with more additional information on setting the column width for multiple Google Sheets columns, including pictures of these steps.
How to Set the Column Width for Multiple Columns in Google Sheets (Guide with Pictures)
This article was performed in the desktop version of the Google Chrome Web browser, but you can use other desktop browsers like Firefox, Edge, or Safari instead.
Step 1: Sign into your Google Drive and open the Sheets file you wish to edit.
Step 2: Click and hold on the column letter of the leftmost column to adjust, then drag right to select the rest of them.
As we discussed above, you could also click on the first column letter, then hold down the Shift key on your keyboard and click on the last column letter that you wish to resize.
Step 3: Right-click on one of the selected columns and choose the Resize columns option.
Step 4: Enter the desired column width into the field, then click OK.
If you don’t like the size of the columns that you set, you can press Ctrl + Z on your keyboard to undo the resizing, then follow the steps above again to retry.
Note that the default column width is 100 pixels.
You also have the option to Fit to data, but that will likely result in differing column widths, as they will adjust based on the size of the largest cell in each column.
More Information on How to Make All Columns Same Width – Google Sheets
While we talked about clicking on the first column letter, then holding down the Shift key and scrolling to the right and clicking the last column letter to select everything, you could also click and drag to select column letters.
Unfortunately you can’t use the methods to select all of your cells (such as clicking the gray button next to column A, or the keyboard shortcut of Ctrl + A) to do this more quickly. The column resizing options will be grayed out when you try with that method.
If you aren’t resizing your columns to the maximum width of your data, then some of your data may not be visible. You might need to select some of your cells and change the text wrapping option for those cells if you want the day to display in a different manner.
The same method that we discuss in this article can also be used to make a bunch of rows the same height. You would just use one of the options to select multiple rows, then choose the Resize rows option and set the desired height of those rows in pixels.
- How to change the orientation of a printed spreadsheet in Google Sheets
- How to sort a column from high to low in Google Sheets
- How to print with gridlines in Google Sheets
- How to copy multiple rows in Google Sheets
- How to change cell border color in Google Sheets
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.