Excel Columns: How to Format, Resize, and Style Them

How-to basics · Updated November 18, 2026

To format a column in Excel for Microsoft 365 on Windows, click its letter at the top of the worksheet, then use the Home tab to set number format, font, fill, alignment, or borders. To change its width, drag the boundary between column letters, or double-click that boundary to AutoFit the contents. Formatting changes how data looks; it usually does not change the value stored in a cell.

What column formatting means in Excel

A column is a vertical set of cells identified by a letter, such as A or B. Selecting the letter above the grid selects the entire worksheet column, including currently empty cells. That makes column-wide formatting useful when you want dates, prices, identifiers, or headings to look consistent as you add more data.

Formatting can include a number display, font, fill color, alignment, borders, text wrapping, and column width. These settings can be applied to a whole column, a selected range within it, or particular cells. For example, format all of column C as Currency if it will hold prices, or format only C2:C50 if the rest of the column serves another purpose.

Keep formatting separate from data structure. A number format may display 0.25 as 25%, but the stored value remains 0.25. Likewise, a date display can show a date in a shorter or longer style without changing the underlying date value. This distinction matters when sorting, calculating, or sharing a workbook.

Choose a number format that fits the data

With a column or range selected, go to Home > Number and choose a format from the number-format list. Common choices include General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, and Text. The list is a quick way to make a column readable, but the choice should reflect what the values mean rather than just how they look.

For example, a price column is usually clearer with a currency symbol and two decimal places, while a percentage column should be displayed as a percentage. Applying Percentage to a stored value of 0.15 displays 15%; applying it to 15 displays 1500%. Excel does not infer that you meant 15 percent, so check whether the underlying values are decimals or whole-number percentages before formatting.

For more control, open the Format Cells dialog with Ctrl+1 on Windows. On Mac, use Command+1. Choose the Number tab to set decimal places, negative-number display, date types, or a custom format. A custom format such as 00000 can display the number 42 as 00042, which can be useful for a fixed-width code. It does not turn that number into text: calculations still treat it as a number.

Identifiers need special care. Account codes, postal codes, and product IDs may contain leading zeroes that are meaningful, even though Excel may interpret an entered value as a number and remove those zeroes. If the value is an identifier rather than a quantity, set the cells to Text before entering or importing the data. A custom number format can restore the appearance of leading zeroes for a consistent numeric length, but the underlying value remains numeric. For mixed-length codes, Text is often the more reliable choice.

Set column width and row height

To set a column width by eye, point to the right edge of its letter heading and drag when the pointer changes to a resize cursor. To fit the widest visible entry, double-click that edge. Excel adjusts the width to accommodate the longest displayed content in the selected column, subject to the available worksheet layout.

You can also select one or more columns and choose Home > Format > Column Width, then enter a value. The unit is based on character width in the workbook’s default font, not a simple number of pixels. For a group of columns, select their letter headings first; the same width setting applies to all selected columns. Home > Format > AutoFit Column Width is an alternative to double-clicking the boundary.

AutoFit is convenient, but it may create an excessively wide sheet if one cell contains a long note or URL. In that case, use a fixed width and turn on Wrap Text from Home > Alignment. The entry will occupy multiple lines within the cell, and you may need to adjust the row height. To set a specific row height, select the row and choose Home > Format > Row Height.

For a quick Windows shortcut, select a column and press Alt, H, O, I in sequence to AutoFit its width; Alt, H, O, W opens the Column Width command. These are ribbon key sequences, not keys to press all at once. On Mac, ribbon shortcuts can differ by Excel version and keyboard settings, so dragging, double-clicking, or using Home > Format is the dependable alternative.

Align text, wrap content, and freeze headings

Use the alignment controls on Home to position content horizontally or vertically. Text is generally left-aligned by default, while numbers are generally right-aligned, but alignment can be changed for readability. For instance, a narrow status column may look clearer centered, while descriptive text often reads better left-aligned.

Wrap Text displays a long entry on multiple lines rather than allowing it to spill into an empty neighboring cell or appear cut off. It changes the presentation, not the stored text. Merge & Center is available for some heading layouts, but merging cells can interfere with sorting, filtering, and selecting data ranges. For a table heading, consider centering the text without merging cells.

Freezing a heading is not column formatting, but it is often useful alongside it. To keep the top row visible while scrolling, choose View > Freeze Panes > Freeze Top Row. To keep a leftmost identifier column visible, select the cell immediately to the right of that column and choose View > Freeze Panes > Freeze Panes. Freeze Panes preserves the view while scrolling; it does not change the data or print layout.

Apply fonts, fills, borders, and table styles

With the target column selected, Home provides controls for font, font size, bold, font color, fill color, and borders. Use these sparingly to make meaning easier to scan. A shaded header and a subtle border between key sections can help distinguish labels from values, while applying multiple bright colors to ordinary data can make a worksheet harder to read.

If the data is a related block with headings, select a cell in it and choose Home > Format as Table. Select a style and confirm whether the table has headers. Excel creates a structured table with filter buttons and consistent table formatting. A table is more than a visual style: it expands as data is added and supports structured references in formulas. Use it when the data behaves like a dataset, not merely to color an isolated column.

Table styles and ordinary cell formatting can coexist, although manual formatting may affect how a table appears. If a style is not visible as expected, check the table’s design options and the direct formatting on the cells. On Mac, the same core formatting controls are available, though ribbon layout and some shortcut details may vary. Excel for the web also offers common number, alignment, font, and fill controls, but its interface and advanced formatting options may not exactly match the Windows desktop application.

Use conditional formatting for changing values

Ordinary formatting stays in place until someone changes it. Conditional formatting applies a visual rule based on cell values, making it useful for highlighting exceptions in a column. Select the relevant cells, then choose Home > Conditional Formatting. Options include Highlight Cells Rules, data bars, color scales, and icon sets.

For example, a service team could apply a rule to a response-time column to highlight values greater than a chosen threshold. If the values later change, the highlighting updates to reflect the rule. Choose rules that communicate something specific, and avoid relying on color alone to convey essential information; labels or other cues can make the sheet clearer for more readers.

When applying a rule to a full column, consider whether the rule should include the header and unused cells. A focused range such as D2:D200 may be easier to manage than D:D when row 1 contains a heading. To inspect or adjust a rule, use Home > Conditional Formatting > Manage Rules. Confirm the rule’s Applies to range if new rows are not receiving the expected formatting.

Copy formatting and manage columns

To reuse a column’s appearance, select a formatted cell or range, choose Home > Format Painter, then select the destination. Double-click Format Painter to apply the same formatting in multiple places, and press Esc when finished. Format Painter copies formatting rather than the cell’s value. Copy and Paste Special > Formats is another option when you want to transfer formatting without replacing destination data.

To select a whole column with the keyboard on Windows, select a cell in it and press Ctrl+Space. The Mac equivalent is Control+Space, though macOS keyboard settings can sometimes use that shortcut for another system feature. To select adjacent columns, click and drag across their letter headings; use Ctrl-click on Windows or Command-click on Mac to select nonadjacent headings.

Other column commands live under Home > Format. Choose Hide & Unhide > Hide Columns to hide selected columns, or Unhide Columns to show hidden ones. Hiding is not deletion: the values remain in the workbook and may still be referenced by formulas. To insert a column, select its heading and choose Home > Insert > Insert Sheet Columns. Deleting a column removes its contents and can affect formulas, so check references before removing it.

Common formatting problems and how to fix them

  • Numbers appear as dates or dates appear as numbers: The cell may have an unsuitable number format. Select the cells and choose a suitable option under Home > Number. If Excel already converted imported text into a date or number, changing the display format may not restore the original characters.
  • Leading zeroes disappear: Excel likely interpreted the entry as a number. Use Text format before entering or importing identifiers, or apply an appropriate custom format when the codes are numeric and a fixed width is appropriate.
  • Values display as hash marks: A column may be too narrow for the formatted value. Widen it or use AutoFit. Hash marks do not necessarily mean the value is lost; inspect the formula bar or widen the column to check.
  • AutoFit makes the sheet unwieldy: A long cell may be setting the width. Use a fixed width with Wrap Text, or shorten the displayed content if appropriate.
  • Formatting does not appear on new entries: The formatting may cover only an existing range. Extend the formatted range, use a table when the data is tabular, or inspect the conditional-formatting rule’s Applies to range.
  • A CSV file loses the formatting: CSV stores plain text values separated by delimiters; it does not preserve Excel’s cell formatting, formulas, multiple worksheets, or table styles. Keep a copy as an Excel workbook (.xlsx) when appearance and workbook features need to be retained.

Frequently Asked Questions

How do I format an entire column in Excel?
Click the column letter to select the whole worksheet column, then use the Home tab to choose number format, font, alignment, fill, or borders. To format only some entries, select the desired cell range instead.

How do I make all columns the same width?
Select the column headings you want to change, choose Home > Format > Column Width, and enter a width. Excel applies that width to every selected column. You can select the entire worksheet using the Select All button above row 1 and left of column A if you intend to change all columns.

How do I automatically fit a column to its contents?
Double-click the boundary on the right side of its column heading, or select the column and choose Home > Format > AutoFit Column Width. If one unusually long entry makes the result too wide, set a smaller width and use Wrap Text instead.

Does formatting a column change its values?
Most formatting changes only how values are displayed. A percentage format, for example, displays 0.25 as 25% without changing the stored value. Some actions, such as typing over a cell or converting data, can change its contents, so formatting and data conversion should not be confused.

Can I format a column in Excel for the web or on Mac?
Yes. Excel for the web and Excel for Mac include common column-width, number-format, and cell-style controls, although their menus and some shortcuts differ from Windows. On Mac, use the Home tab or the Format Cells dialog, and check the application’s current shortcut guidance if a Windows key sequence does not apply.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.