New: ready-to-use spreadsheet templatesExplore the collection  →
Google Sheets · Verified tutorial

Make all columns the same width in Google Sheets

Make columns A:D the same width: exactly 120 pixels.

Verified by JosephineAbout 60 seconds
Quick answer

Make columns A:D the same width: exactly 120 pixels.

Step-by-step

1

Open the practice sheetUse the example data shown below so the result is easy to check.

2

Make all columns the same widthMake columns A:D the same width: exactly 120 pixels.

3

Check the resultCompare the finished sheet with the expected result and correct the target range if needed.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

Columns A:D are all 120 pixels wide.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Undo the last change, reselect the intended range, and try again. Columns A:D are all 120 pixels wide.

Example spreadsheet data

This is the clean fixture used for the verified run.

ItemOwnerStatusAmount
WebsiteAnnaOpen1200
CampaignBenClosed850
ResearchCaraOpen640

Video transcript

  1. Open the prepared Practice spreadsheet.
  2. Open the practice sheet. Use the example data shown below so the result is easy to check.
  3. Make all columns the same width. Make columns A:D the same width: exactly 120 pixels.
  4. Check the result. Compare the finished sheet with the expected result and correct the target range if needed.
  5. Columns A:D are all 120 pixels wide.