Adjust Column Width

Excel Guides / Shortcuts & Formatting

Shortcuts & Formatting

Resize columns with the mouse, set an exact width, AutoFit to the contents and do it all from the keyboard.

Updated 12 Oct 2026 Ā· 6 min read Ā· By Sky Dashboards

Column width sounds like housekeeping, but it decides whether a sheet can be read at a glance. Too narrow and numbers turn into ####. Too wide and the eye loses the row it was following. This guide covers every way to set the width, from a quick drag to keyboard shortcuts you can run without touching the mouse.

Why column width matters

Excel measures column width in characters: the number of digits of the default font that fit in the cell. A new sheet starts at 8.43 characters, which is 64 pixels with the standard font. Anything that does not fit is handled differently depending on what it is:

  • Numbers and dates are never cut off. If they do not fit, Excel shows #### (or switches a long number to scientific notation) until you widen the column.
  • Text spills into the next cell when that cell is empty, and is clipped when it is not.
  • Columns that are too wide spread a table across the screen, so you scroll sideways and lose track of which row you are on.
A B C
1 Product Units Revenue
2 Soy candle 312 ######
3 Wax melt 540 ######
4 Gift set 96 ######

Column C is too narrow for the revenue figures, so Excel shows #### instead of the values.

A B C
1 Product Units Revenue
2 Soy candle 312 $7,488.00
3 Wax melt 540 $4,860.00
4 Gift set 96 $3,360.00

The same sheet after AutoFit on column C.

Keep widths consistent

In a model or dashboard, give every column of the same type the same width: all month columns at 11, all label columns at 28, and so on. Consistent widths make the sheet look deliberate and make it obvious when something has been inserted out of place.

Change column width with the mouse

The fastest way for a one-off change:

  1. Hover over the right-hand border of the column letter in the header row. The pointer turns into a double-headed arrow.
  2. Drag right to widen or left to narrow. A tooltip shows the width in characters and pixels as you drag.
  3. Release the mouse button when the width looks right.

Double-click the same border instead of dragging and Excel AutoFits the column to its longest entry. More on AutoFit below.

Set an exact column width

Dragging is quick but imprecise. When several columns need to match, type the number instead:

  1. Select the column or columns. Click a column letter, or press Ctrl + Space to select the column of the active cell.
  2. On the Home tab, in the Cells group, click Format.
  3. Choose Column Width...
  4. Type the width in characters, for example 12, and press Enter.

You can also right-click a selected column letter and choose Column Width... from the menu. The dialog is the same.

Note

Widths are entered in characters. To work in centimetres or inches, switch to View > Page Layout first: the rulers and the Column Width dialog then use the unit chosen under File > Options > Advanced > Ruler units.

Keyboard shortcut for column width

Excel has no single key combination for column width, but the ribbon's key tips give you one. Press each key in turn rather than holding them down:

āŒØĀ  Open the Column Width dialog

Alt ā†’ H ā†’ O ā†’ W

Press the keys one after another, not together.

Alt activates the ribbon, H opens Home, O opens Format, W picks Column Width.

Combine it with Ctrl + Space to select the column first and you can resize without the mouse: Ctrl + Space, then Alt H O W, type the width, Enter.

Action Shortcut
Select the entire column Ctrl + Space
Column Width dialog Alt ā†’ H ā†’ O ā†’ W
AutoFit Column Width Alt ā†’ H ā†’ O ā†’ I
Default Width dialog Alt ā†’ H ā†’ O ā†’ D
Row Height dialog Alt ā†’ H ā†’ O ā†’ H
AutoFit Row Height Alt ā†’ H ā†’ O ā†’ A

Note

Key tips are a Windows feature. On a Mac, use Format > Column > Width in the menu bar, or Home > Format > Column Width on the ribbon.

AutoFit column width

AutoFit sets the width to fit the longest entry in the selection, so nothing is clipped and nothing is wasted. There are three ways to run it:

  • Double-click the right border of the column header.
  • Home > Format > AutoFit Column Width.
  • Press Alt H O I in sequence.

āŒØĀ  AutoFit Column Width

Alt ā†’ H ā†’ O ā†’ I

Press the keys one after another, not together.

AutoFit to some cells only

Double-clicking the header fits the column to every cell in it, including a long title in row 1. The ribbon command and Alt H O I only look at the cells you have selected. Select the data range without the title, press the shortcut, and the column fits the numbers while the title spills across as before.

Watch out

AutoFit is a one-off. If the values change later, the width does not follow. Run it again after a refresh, or set a fixed width that leaves room for the largest number you expect.

Resize several columns at once

  • Same width for a block: select the column letters (drag across them, or Shift-click the last one), then drag any one border or use Alt H O W. Every selected column gets the new width.
  • Columns that are not side by side: hold Ctrl while clicking each column letter, then set the width.
  • AutoFit the whole sheet: press Ctrl + A (press it again if it only selects the current block of data) or click the triangle at the top-left corner of the grid, then double-click any column border.

Copy column widths to another sheet

Paste Special can copy widths without touching the contents of the destination:

  1. Select the source columns and press Ctrl + C.
  2. Click the first cell of the destination column.
  3. Press Ctrl + Alt + V to open Paste Special, press W for Column widths, then Enter.

āŒØĀ  Paste column widths only

Ctrl + Alt + V ā†’ W ā†’ Enter

Change the default column width

If a sheet needs wider columns everywhere, change the default instead of resizing each one. Go to Home > Format > Default Width... (or press Alt H O D) and type a new value. Every column you have not resized by hand switches to it. Columns you have already set keep their width.

The setting applies to the active sheet only. To change it for every new workbook, set it in a blank workbook and save that as your default template (Book.xltx in the XLSTART folder).

Column width in dashboard layouts

Every Sky Dashboards template is laid out on the cell grid, so column widths do the job a design tool's layout grid would do. A few habits that keep things tidy:

  • Spacer columns. Set narrow columns (width 2 or 3) between tiles. They act as gutters and keep KPI cards evenly spaced.
  • One width per role. Tile columns share one width, label columns another. Moving a chart from one tile to another then never needs resizing.
  • Snap charts to cells. Hold Alt while dragging or resizing a chart and its edges snap to the cell borders, so charts line up with the widths you set.
  • Hide gridlines last. Lay out with gridlines on, then turn them off on the View tab when the widths are final.

Tip

Rows behave the same way, except that row height is measured in points rather than characters. Use Alt H O H to set it and Alt H O A to AutoFit.

Frequently asked questions

What is the default column width in Excel?

8.43 characters, which is 64 pixels with the default font. You can change it for a sheet with Home > Format > Default Width.

Why does my column show ####?

The column is too narrow to show a number or date in full. Widen it or AutoFit it. A negative date or time value also shows ####, and widening will not fix that.

What is the widest a column can be?

255 characters. The narrowest is 0, which hides the column.

Is there a shortcut to AutoFit columns?

Yes. Select the cells, then press Alt, H, O, I one after the other. Double-clicking the column border also AutoFits.

Want the finished dashboard instead?

My Excel templates come with these formulas already wired up. Pick one, type in your own rows and the charts update.

Browse templates ā†’

Related guides

All 32 Excel guides