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

Resize columns in Google Sheets

Resize columns A:D to exactly 140 pixels using the column headers.

Verified by JosephineAbout 60 seconds
Quick answer

Resize columns A:D to exactly 140 pixels using the column headers.

Step-by-step

1

Select the targetResize columns A:D to exactly 140 pixels.

2

Apply the changethe column headers.

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 140 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 140 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. Select the target. Resize columns A:D to exactly 140 pixels.
  3. Apply the change. the column headers.
  4. Columns A:D are 140 pixels wide.