How to make a column wider in Google Sheets
Learn how to widen columns in Google Sheets by dragging, using the Resize column dialog, or auto-fitting to content.
Quick answer
To make a column wider in Google Sheets, click and drag the right border of the column letter header, or right-click the column and select Resize column to enter an exact pixel width. Double-click the border to auto-fit the column to its widest content instantly.
Steps at a glance
- Click the column letter to select the column
- Hover over the right border of the column header
- Click and drag the border right to widen it
- Or right-click the column and choose Resize column
- Enter an exact pixel width and click OK
- Double-click the border to auto-fit to content
Summary
Adjusting column width in Google Sheets lets you display long text, numbers, or dates without truncation. Google Sheets offers both manual dragging and precise numeric input, so you can quickly fit content to your needs whether you're working with a single column or an entire sheet.
Step-by-step guide
Step 1
Select the column you want to resize
Click the column letter at the top of the sheet (for example, column B) to highlight the entire column. To resize several columns at once, click and drag across multiple letters, or hold Shift and click each additional letter you want included.
Step 2
Drag the column border to widen it manually
Move your cursor to the right edge of the selected column's letter header until it turns into a double-sided arrow. Click and hold, then drag to the right to make the column wider, or drag left to narrow it. Release the mouse button when you're happy with the size.
Step 3
Right-click and choose Resize column for an exact width
If you need a precise measurement rather than an eyeballed drag, right-click any selected column letter and choose Resize column from the menu. A dialog box appears where you can type an exact width in pixels.
Step 4
Enter a pixel value and confirm
Type the desired width into the input field of the Resize column dialog. Click OK to apply the new width to all selected columns at once, which is useful for keeping several columns uniform.
Step 5
Auto-fit the column to its content
Double-click the right border of a column header to instantly resize it to match the widest piece of content in that column. This removes extra white space and prevents text from spilling into neighboring cells, especially helpful after you add columns or paste in new data.
Step 6
Check row alignment after resizing
Widening columns can sometimes make a sheet look uneven if row heights weren't adjusted to match. Visit the guide on how to edit row size at /guides/google-sheets/edit-row-size if your rows also need adjusting for a cleaner layout.
Why this matters
You're staring at a spreadsheet where product names or long email addresses get cut off mid-word, forcing you to guess what's hidden. Widening the right columns makes your data readable at a glance, which matters when you're sharing a sheet with a client or team member.
Frequently asked questions
How do I make all columns the same width at once?
Select all the columns you want to match by clicking and dragging across their letter headers, then right-click and choose Resize column. Enter a single pixel value and click OK to apply that width to every selected column.
Can I make a column wider without using my mouse?
Yes. Select the column by clicking its letter, then right-click and choose Resize column to open a dialog where you can type an exact pixel width and press OK, avoiding manual dragging entirely.
What's the fastest way to fit a column to its content?
Double-click the right border of the column's letter header. Google Sheets automatically adjusts the width to match the longest entry in that column, so nothing gets cut off.
Create interactive demos like this one — free, no coding required.
Start for free →