To make multiple columns the same width in Google Sheets, select the columns by clicking and dragging across their letters (or hold Ctrl/Command to pick separate columns). Right-click one of the selected letters, choose Resize columns, select Specify column width, type a width in pixels (the default is 100), and click OK. Every selected column now has the same width.
Below are faster ways to resize, how to fit columns to their content, and how to do the same for rows.
Method 1: Resize columns dialog
- Click the first column letter, hold Shift, and click the last one. Or hold Ctrl (Command on Mac) to select non-adjacent columns.
- Right-click a selected letter and choose Resize columns.
- Choose Specify column width and enter a number, like 120.
- Click OK.
Method 2: Drag one column border
With several columns selected, drag the right border of any selected column letter. All selected columns change to the same width as you drag.
Method 3: Fit columns to their content
Select the columns and choose Resize columns > Fit to data, or double-click the border between two selected column letters. Each column resizes to fit its widest entry, so widths will differ.
Make rows the same height
Select the row numbers, right-click, choose Resize rows, and enter a height (the default is 21 pixels).
Select all columns at once
Click the gray box in the top-left corner of the grid (above row 1 and left of column A), or press Ctrl + A twice, then resize. This is a quick way to make an entire sheet uniform.
Frequently asked questions
What unit does Google Sheets use for column width?
Pixels. 100 pixels is the default width.
Can I set column width in inches?
No, only pixels. For printing, check File > Print and use Scale options to fit the page.
Does this work in the Google Sheets app?
Yes. Tap a column letter, drag the blue handle to select more, then drag the column edge to resize them together.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.