How to resize columns to fit content in Google Sheets

Created on 2/12/2023 by Dean

Resize a single column

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

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

2To 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

3Click 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

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

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

5You'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.