Last Updated on October 30, 2023 by Jake Sheridan
How To Set Column Width In Google Sheets
When you’re working with different types of data in Google Sheets, sometimes the default column width is too narrow or too wide to properly display the data in that column.
If you need to set the width of a column or columns in Google Sheets, follow these steps:
Highlight the column or columns you want to select.
To highlight multiple items, hold down Ctrl on Windows or Command on Mac while you select the columns
Right click on the columns and select Resize Column:
In the dialog that appears, type in the new column width.
Widths are set in pixels with the default being 100 pixels.
You can also choose the Fit To Data option to let Google Sheets select a column width based on the data currently in that column.
Click OK when you’re done to resize the columns
A Fit to Data Shortcut
There’s a faster way to resize columns in Google Sheets if you want to use the Fit To Data option.
Instead of bringing up the column Resize dialog and selecting Fit To Data every time, you can follow these steps:
Hover your mouse over the right-hand border of the column header until the border highlights blue and your cursor turns into a double horizontal arrow:
Without moving your mouse, double click on the highlighted border
The column will resize to fit its data
If you want to use this method for multiple columns, simply select all the columns first, then use this method on the any of the columns within the selection and all columns in the selection will resize:
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to set column width in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
More ways to use columns in Google Sheets:
- Move A Column
- Add A Column
- Delete Columns
- Rename A Column
- Compare Two Columns
- Make All Columns The Same Width
- Add Multiple Columns
- Apply A Formula To An Entire Column
- Sort Multiple Columns
- Auto Fit Column Width
- Group Columns
- How To Name Columns
- Sum A Column
- Sort By Column
- Lock Column
- Split Text into Columns
- Apply Formula To Entire Column
- Combine Columns
- Find Unique Values In Column
- Move Columns
- Filter Columns
- Filter Multiple Columns
- Split A Column
- Get the Last Value in a Column
- Convert Rows To Columns
- Multiply Columns
- Highlight Duplicates In Multiple Columns
- Switch Columns
- Select Multiple Columns
- Subtract Columns
- Number A Column