How to Format Cells in Excel: A Practical Guide

Cell formatting controls how worksheet data looks and how readers interpret it. It can display the same stored number as a decimal, percentage, currency amount, date, or time without changing the value Excel uses in calculations.

Good formatting does more than decorate a sheet. It distinguishes labels from inputs, makes units clear, guides attention to totals, and keeps repeated sections consistent. The safest approach is to decide what the data means first, then choose a format that communicates that meaning.

Menu paths below use current desktop Excel for Windows. Excel for Mac and Excel for the web provide the same core formatting categories, although some dialog boxes, shortcuts, and advanced options differ.

Formatting changes the display, not the stored value

Suppose cell B2 contains 0.125. Excel can display that value in several ways:

The formula bar shows the underlying value, while the cell shows the formatted result. A currency display does not turn a number into different data, and reducing visible decimal places does not remove the hidden precision used in calculations.

Formatting is not data conversion. If a number is stored as text, applying a Number format may not turn it into a numeric value. Likewise, changing a date’s appearance does not repair text that Excel never recognized as a date.

Open the right formatting controls

The Home tab contains the commands used most often:

• Font controls typeface, size, bold, italic, font color, fill color, and borders.
• Alignment controls horizontal and vertical position, wrapping, orientation, indentation, and merging.
• Number controls number categories, decimal places, separators, currency, and percentage display.
• Styles contains Cell Styles, Conditional Formatting, and table-formatting options.

For the complete set of options, select the cells and press Ctrl+1 in Excel for Windows. On Mac, use Command+1. You can also right-click the selection and choose Format Cells.

The desktop Format Cells dialog organizes settings into Number, Alignment, Font, Border, Fill, and Protection tabs. You can change several categories before selecting OK.

Match the number format to the meaning

Choose number formats based on what the values represent, not merely how many digits you want to see.

Microsoft’s number-format reference explains the built-in categories and their behavior.

Format percentages from the correct input

Percentage format multiplies the displayed value by 100 and adds a percent symbol. Enter 0.075 when the intended value is 7.5%, then apply Percentage. If you type 7.5 first and apply Percentage afterward, Excel displays 750% because the stored value is already 7.5.

Use decimals that match the decision

Showing two decimal places can make money columns consistent, but it does not round the stored values. If calculations must use rounded values, apply an appropriate formula such as ROUND; do not rely on the display alone.

Format a small report in a reliable order

Formatting is easier to maintain when you work from meaning to emphasis:

1. Select the date column and apply a consistent Date format.
2. Select amount columns and apply Currency or Accounting with the required decimal places.
3. Select rate columns and apply Percentage only after confirming that the stored values are ratios.
4. Format the header row with a clear font treatment and sufficient contrast.
5. Use borders or fill to separate sections, not to decorate every cell.
6. Adjust column widths and enable Wrap Text where labels need more room.
7. Review the sheet at normal zoom and check that totals, inputs, and labels are easy to distinguish.

This order prevents a common mistake: making the sheet visually polished before confirming that dates, percentages, and amounts have the correct meaning.

Control alignment without damaging the layout

Text normally aligns to the left and numbers to the right under the General format. Change alignment when it improves scanning, not merely to make every column look centered.

• Wrap Text displays long content on multiple lines within the same cell. Excel may adjust the row height, or you can AutoFit it.
• Horizontal and vertical alignment position content within the cell.
• Indent can create a visual hierarchy without inserting spaces into the cell value.
• Orientation rotates text when narrow headers genuinely need it.

Use Merge & Center cautiously

Merging combines adjacent cells into one larger cell. When the selected cells contain data, Excel retains only the content from the upper-left cell in left-to-right worksheets and discards the other contents. Merged cells can also complicate selection, filtering, and later layout changes.

Before merging, move all content you need to keep into the upper-left cell. For structured data, prefer a separate title row or another layout that leaves the data grid unmerged.

Microsoft’s merge-and-unmerge guide explains how Excel retains content.

Create visual hierarchy with restraint

Fonts, fills, and borders should reveal structure. A simple system is usually enough:

• Use a larger or bold font for the sheet title and section headings.
• Use one consistent header treatment for comparable tables.
• Reserve a light fill for input cells or another clearly defined category.
• Use borders to mark table edges, totals, or section breaks rather than outlining every cell heavily.
• Keep body text readable and avoid excessive font changes, italics, underlining, or all-capital labels.

Color should reinforce meaning, not carry it alone. Pair a color cue with a label, icon, border, or text treatment, and use enough contrast between text and its background. Microsoft’s Excel accessibility guidance recommends checking color contrast and using familiar, readable fonts.

Reuse formatting instead of recreating it

Copy a nearby format with Format Painter

Select the correctly formatted cell, choose Home > Format Painter, and select the destination. Double-click Format Painter when you need to apply the format to several separate areas, then press Esc when finished. Microsoft’s Format Painter guide documents the same workflow for current Excel versions.

Format Painter copies the source formatting, including elements such as number format, font, fill, alignment, and borders. Check the destination afterward so an unwanted number format does not travel with the visible design.

Use Cell Styles for repeated roles

A Cell Style is a named set of formatting characteristics. Built-in styles can mark headings, input cells, output cells, warnings, and totals. Custom styles help repeated sections stay consistent, and theme-based styles respond when the workbook theme changes.

Use Home > Cell Styles to apply a style. Microsoft’s Cell Styles guide covers built-in, custom, and modified styles.

Use custom number formats for display rules

A custom number format changes presentation without changing the stored value. Open Format Cells > Number > Custom, start with a built-in code, and adjust it carefully.

Separators, currency symbols, and available formats can vary with regional settings. Use Microsoft’s custom number-format guidelines when the code needs conditions, colors, text, or separate positive and negative sections.

A custom format such as 000000 adds visible leading zeros but leaves the value numeric. Use Text when the zeros are part of an identifier that must remain text, especially for import, export, or exact matching.

Remove formatting without deleting the data

Select the cells, then use Home > Clear > Clear Formats to remove formatting while keeping values and formulas. This clears number formats, borders, fills, and other applied formatting from the selection.

Microsoft’s clear-cells guide explains how these commands also handle comments, notes, and hyperlinks.

Understand the Protection tab

The Locked and Hidden options on the Protection tab do not protect a cell by themselves. They take effect only after worksheet protection is enabled.

For a sheet with editable input cells, the usual sequence is:

1. Select the cells users should be allowed to edit.
2. Open Format Cells > Protection and clear Locked.
3. Select Review > Protect Sheet.
4. Choose the actions users may perform and, if needed, set a password.

Worksheet protection helps prevent changes to locked cells; Microsoft does not describe it as a security feature for confidential data. Use file-level access controls and appropriate encryption when confidentiality matters.

See Microsoft’s worksheet-protection guide for the current Windows and web options.

Fix common cell-formatting problems

Excel cell-formatting questions

Make the format explain the data

Start with the value’s meaning, choose the correct number category, and then add only enough visual structure to guide the reader. Reuse styles for consistency, keep color accessible, and separate formatting cleanup from content deletion. The best-formatted worksheet is not the busiest one; it is the one readers can interpret without guessing.