To make columns the same width in Google Sheets, select the columns by clicking and dragging across their letters, right-click any selected letter, choose Resize columns, select Specify column width, enter a number of pixels, and click OK. Every selected column becomes that width.
Google Sheets doesn’t have a “Distribute columns” button like Word or Excel tables, but this gives the same result. Below are three ways to do it, plus non-adjacent columns, rows, and printed pages.
Method 1: Set an exact width with Resize columns
This is the most precise way to distribute columns evenly.
- Click the letter of the first column you want to change, such as A.
- Hold Shift and click the letter of the last column, such as F. All the columns in between are selected.
- Right-click any of the selected column letters.
- Choose Resize columns A – F (the letters match your selection).
- Select Specify column width and type a width in pixels. The default column width in Google Sheets is 100.
- Click OK.
To pick a width that fills the screen, divide the total width you want by the number of columns. For example, six columns across about 900 pixels means a width of 150 each.
Can I set a default column width for new sheets?
There’s no global setting. Create a sheet with your preferred widths and use it as a template by making a copy each time.
Method 2: Drag one column border
- Select the columns you want to make equal, as in Method 1.
- Hover over the right edge of any selected column letter until the cursor turns into a double arrow.
- Drag to the width you want and release.
All selected columns snap to the same width as the one you dragged. This is quicker when you’re judging by eye rather than using an exact number.
Method 3: Fit columns to their data
If you’d rather each column be just wide enough for its contents, select the columns, right-click, choose Resize columns, and pick Fit to data. You can also double-click the border between two selected column letters. Note that this makes columns fit their content, so they usually end up different widths. Use Method 1 afterward if you want them uniform.
Copy column widths from another range
If one part of your sheet already has the widths you like, you can copy them. Select the columns with the widths you want and press Ctrl + C. Select the destination columns, right-click, and choose Paste special > Column widths only. The widths copy over without changing any cell contents or formatting. This also works between tabs in the same spreadsheet.
Make non-adjacent columns the same width
To resize columns that aren’t next to each other, hold Ctrl (or Command on a Mac) and click each column letter, for example A, C, and E. Then right-click one of them and use Resize columns as above. The columns in between stay the same.
Select every column at once
Click the gray box in the top-left corner of the sheet, above row 1 and to the left of column A, or press Ctrl + A (Command + A on a Mac). Then right-click any column letter and resize. Every column on the sheet becomes the same width.
Distribute rows evenly too
The same steps work for rows. Select the row numbers, right-click, choose Resize rows, and enter a height in pixels. The default row height is 21 pixels. If text wraps in a cell, a row may need to be taller, so check that nothing gets cut off. See how to set row height in Google Sheets for more.
On the Google Sheets mobile app
- Tap a column letter to select it.
- Drag the blue handle on the edge of the selection to include more columns.
- Drag the edge of a column header to resize. On many devices, the change applies to every selected column.
For exact pixel widths, the desktop browser version is easier.
Fit columns on a printed page
Equal widths don’t guarantee everything fits on paper. When printing, go to File > Print, and under Scale choose Fit to width. Google Sheets shrinks the columns proportionally so they all fit across the page.
Keep resized columns readable
- Turn on text wrapping (Format > Wrapping > Wrap) so long entries stay readable in narrower columns.
- Freeze your header row so column labels stay visible while scrolling.
- If a column shouldn’t be visible at all, hide it instead of making it tiny.
Related: How to insert a column in Google Sheets.
Related: Use autofill in Google Sheets.
Related: Adjust column width in Google Sheets.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.