How to resize all columns in Google Sheets
Learn how to resize all columns in Google Sheets at once using select-all, right-click menus, and Fit to data for a clean layout.
Quick answer
Select every column in your sheet by clicking the blank box above row 1 and left of column A, then right-click any column header and choose Resize columns. Pick Fit to data for automatic sizing, or enter a custom pixel width to make all columns uniform in one action.
Steps at a glance
- Open your Google Sheets file and select the sheet tab
- Click the blank corner box to select all columns
- Right-click any column letter to open the menu
- Choose Resize columns from the context menu
- Select Fit to data or enter a custom width
- Click OK to apply the new sizing
- Check row heights next if data still looks cramped
Summary
Google Sheets lets you resize every column in a sheet simultaneously instead of dragging each border individually. This is especially useful for large datasets, imported spreadsheets, or reports where uneven column widths make information hard to scan.
Step-by-step guide
Step 1
Open your spreadsheet
Open the Google Sheets file you want to format and navigate to the specific tab containing the columns you want to resize. If your data spans multiple tabs, repeat this process on each one separately.
Step 2
Select all columns on the sheet
Click the small blank rectangle in the top-left corner of the grid, where the row numbers and column letters meet. This highlights the entire sheet, including every column and row, so any width change applies uniformly.
Step 3
Open the column resize menu
Right-click on any column letter along the top of the sheet while everything is still selected. A context menu will appear with several options, including one labeled Resize columns.
Step 4
Choose a resizing method
In the Resize columns dialog box, pick Fit to data to let Google Sheets automatically adjust every column to match its widest cell content. Alternatively, select Specify width and type a pixel value if you want uniform, identical column widths across the entire sheet.
Step 5
Apply the change
Click OK to confirm your selection and instantly resize every column in the sheet. Scroll across the spreadsheet to confirm the new widths display your data clearly without truncating text or leaving excess white space.
Step 6
Adjust individual columns if needed
If one or two columns still look too narrow or too wide after the bulk resize, click and drag that specific column's right border manually. For more control over a single column, see the guide on how to make a column wider in /guides/google-sheets/make-a-column-wider.
Step 7
Review row heights for a polished look
Wide columns with wrapped text sometimes need taller rows to display everything properly. Check out the guide on how to edit row size in /guides/google-sheets/edit-row-size to fine-tune spacing after resizing your columns.
Why this matters
You've just imported a spreadsheet with dozens of columns, and the widths are wildly inconsistent — some text is cut off, others have huge empty gaps. Resizing all columns at once gives you a clean, readable layout in seconds instead of dragging each border by hand.
Frequently asked questions
Can I resize all columns in Google Sheets without a paid plan?
Yes, this feature is fully available on the free Google Sheets plan tied to any Google account. No upgrade or add-on is required to select columns and use the Resize columns menu.
Does resizing all columns affect data or formulas?
No, changing column width is purely a visual adjustment and never alters cell values, formulas, or formatting. You can resize columns freely without any risk to your underlying data.
What's the difference between Fit to data and a custom width?
Fit to data automatically sizes each column based on its own widest cell content, so widths vary by column. A custom width applies the exact same pixel measurement to every selected column, creating a uniform grid look.
Create interactive demos like this one — free, no coding required.
Start for free →