How to Change the Width of Multiple Columns in Google Sheets

Have the sizes of the columns in your Google Sheets spreadsheet become unruly? Or is data becoming difficult to read because it is obstructed by other columns? Then resizing those columns is definitely something that you will want to do. But individually resizing multiple columns can be a little annoying, especially when you are working with a large sheet.

Fortunately Google Sheets allows you to change the width of multiple columns simultaneously. You can achieve this by selecting the columns that you want to resize, then manually adjusting the width of one of those selected columns. All the rest of the selected columns will then resize themselves as well based on your setting.

Need to combine some of your cells into one? Find out how to merge cells in Google Sheets and achieve your desired result.

Change Multiple Column Widths at the Same Time in Google Sheets

The steps in this article are going to show you a quick way to change the width of multiple columns in a Google Sheets spreadsheet. You will be able to select individual columns that you would like to make the same size, or you can select all of the columns in the spreadsheet at once.

Step 1: Go to your Google Drive at and double-click on the Sheets file containing the columns that you would like to resize.

Step 2: Click the button above row 1 and to the left of column A to select the entire spreadsheet. Alternatively you can hold down the Ctrl key on your keyboard and click the column letter for each column that you would like to make the same size.

change the size of more than one column at once in google sheets

Step 3: Click on the right border of one of the selected columns, then drag that border to the left or right until it is the desired size. The rest of the selected columns will resize to that size as well once you release the mouse button.

how to resize multiple columns in google sheets

Are you collaborating on a Google Sheets file with multiple people, and the current version of the file has a lot of mistakes or problems? Learn how to restore a previous version in Sheets so that you can work on the document from a previous point in time when it was working properly, or contained the correct data. newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.