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.

 

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 https://drive.google.com/drive/my-drive 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.

birthday t-shirts for boys
vintage t rex t-shirt

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