How to resize columns to fit content in Google Sheets

Created on 2/12/2023 by Dean

Resize a single column

2Go to the spreadsheet you'd like to resize the columns on

Go to the spreadsheet you'd like to resize the columns on

3To resize a single column, double-click the divider between two columns

To resize a single column, double-click the divider between two columns
The divider can also be dragged to set the width of the column manually.

Resizing all columns at once

6Click box in the top left (above row "1", and before column "A") to select the entire document

Click box in the top left (above row "1", and before column "A") to select the entire document

7While selected, double click any column divider to automatically resize all columns

While selected, double click any column divider to automatically resize all columns

8You're done! All columns have been resized.

You're done! All columns have been resized.
Dean wrote this guide in 17 seconds, you could too.