The quickest way to adjust column width

Double-click the line between two column letters at the top of your spreadsheet. Excel automatically widens the left column to fit whatever text or numbers are inside it. This is called auto-fit, and it saves you from guessing the right width.

If you want to set the width yourself instead, click and drag that same line to the left or right. The column stretches or shrinks as you move your mouse. Release when it looks right.

Both methods work on a single column. If you need to change several columns at once, select them first by clicking one column letter, then holding Shift and clicking another column letter further right. Then double-click any line between the selected columns, or drag one to resize them all together.

Key Takeaways

  • Double-click the line between column letters to auto-fit a column to its contents in one action.
  • Click and drag that same line left or right to manually set any width you want.
  • Select multiple columns by clicking one letter, holding Shift, and clicking another, then resize them all at once.
  • The Format menu offers a dialog box if you need to set an exact width in inches or centimeters.
  • Column width does not change the actual data — only how it appears on screen.

Dragging the column border for precise control

Position your cursor on the line between two column letters until it changes to a resize cursor — it looks like a double-headed arrow. Then click and hold, and drag left to make the left column narrower or right to make it wider.

This method gives you full control but requires a steady hand. If you overshoot, just drag again. The column width updates live as you move, so you can see exactly how your data looks before you release the mouse.

If you want to hide a column entirely without deleting it, drag the line all the way to the left until the column disappears. The data stays in the spreadsheet — it just does not show on screen. Right-click the column letter and select "Unhide" to bring it back.

Using the Format menu for exact measurements

Click the column letter to select the entire column, then go to the Format menu at the top. Select "Column Width" and type a number. Excel measures in character widths — the number you enter is how many characters wide the column will be.

If you want to use inches or centimeters instead, select "Optimal Width" from the same Format menu, and Excel calculates the smallest width that fits all the text in that column without cutting anything off. This is the same as double-clicking the column border, but it goes through the menu instead.

The Format menu also has a "Hide Column" option if you prefer not to drag. Select the column first, then use Format > Hide Column. To unhide, select the columns on either side of the hidden one, right-click, and choose "Unhide Column".

When columns are too narrow and text gets cut off

If a cell contains text that does not fit, Excel shows only what fits and cuts off the rest. Numbers behave differently — if a number is too wide, Excel displays a row of hash marks (####) instead of the number itself. This is Excel's way of telling you the column is too narrow.

The fastest fix is to double-click the column border. Excel measures the longest entry in that column and widens it just enough. If you have many columns with this problem, select all of them at once and double-click any border between them.

Text that overflows into an empty cell next to it will still appear cut off if you widen the column that contains it but not the cell itself. The text is still there — it just displays across the boundary. Widen the column to see the full text, or use the Format menu to set "Wrap Text" so the text breaks into multiple lines within the same cell.

Resizing all columns to the same width at once

Click the box in the top-left corner of your spreadsheet — the intersection of the row numbers and column letters. This selects every cell. Then double-click any line between two column letters, and Excel auto-fits every column to its contents.

If you want all columns to be exactly the same width instead, select them all the same way, then use Format > Column Width and enter a number. Every column becomes that width.

You can also select a range of columns without selecting the whole sheet. Click the first column letter you want to resize, hold Shift, and click the last one. Then drag any border between them, or use the Format menu. Only the selected columns change.

Column width and printing

Column width on screen does not always match how wide columns print. Excel has separate settings for screen display and print layout. If your spreadsheet looks right on screen but columns are too narrow when you print, check the Page Layout menu (or Layout in newer versions) and look for print scaling or page setup options.

You can also use Print Preview to see how your columns will look on paper before you print. Go to File > Print Preview, and Excel shows you the exact page breaks and column widths as they will appear in print.

If a column is very wide on screen but you want it narrower in print, you can hide it for printing only. Select the column, go to Format > Column > Hide, and it will not print — but it stays visible on screen. Unhide it the same way after printing if you need it back.

Frequently Asked Questions

Can I set a minimum or maximum column width?

Excel does not have built-in minimum or maximum width limits you can lock in. You can set a specific width using the Format menu, but nothing stops you or someone else from changing it later. If you need columns to stay a certain width, document the width in a note or set it each time you open the file.

What happens to my data if I make a column narrower?

Your data does not change — only how it displays. If text gets cut off or a number shows as ####, the actual content is still there. Widen the column again and you will see everything. Narrowing a column never deletes or alters the information inside it.

How do I resize a column on my phone or tablet?

Excel on mobile devices does not support dragging column borders the way the desktop version does. You can use the Format menu if your mobile app has it, or switch to a desktop or laptop to adjust column widths. Some mobile spreadsheet apps like Google Sheets allow pinch-to-zoom, which can make columns appear wider without actually changing their width.

Why does my column width keep changing when I type?

You may have auto-fit turned on. Check the Format menu — if "Optimal Width" is enabled, Excel automatically widens columns as you add longer text. You can turn this off by setting a specific width manually using Format > Column Width, which locks the width in place.