How to Format Excel Cells: A Step-by-Step Guide

Excel cell formatting controls how values look without necessarily changing the underlying value. You can format numbers, dates, alignment, borders, fills, fonts, and protection.

Money columns have their own choice to make between Currency and Accounting, which decides where the dollar sign appears in the cell.

How to format cells in Excel

  1. Select the cells you want to change.
  2. Use the Home tab for common number, font, alignment, border, and fill controls.
  3. For more options, open Format Cells with Ctrl+1.
  4. Choose the relevant category and settings, then apply them.

Formatting does not always change data

A date is normally stored as a serial value, and currency formatting does not turn a number into different arithmetic. Likewise, displaying fewer decimal places does not necessarily round the stored value.

Use styles for repeated designs

If the same formatting appears throughout a workbook, Cell Styles or table styles can be easier to maintain than manually formatting each range. Conditional Formatting is appropriate when appearance should change according to a value or formula.

Before applying broad formats to imported data, confirm numbers are actually numeric rather than text; formatting alone will not repair every data-type problem.

Why won’t my numbers add up after formatting?

They may be stored as text. Look for a green triangle in the cell corner, then select the cells and choose Convert to Number.

After making the change, test the specific result before doing more. For how to format excel cells: a, keep the original settings or data available until you are satisfied the new configuration works as intended.

Cells that still look like blue links after a paste often need the steps to strip hyperlinks from Excel cells before you format them.

Check the result

Before finishing this format excel cells task, review the changed setting and confirm that the resulting behavior matches what you intended. Leave unrelated settings alone while testing format excel cells so the result can be traced to this change. If format excel cells produces an unexpected result, undo the most recent change first and troubleshoot that symptom before making additional adjustments. Testing format excel cells in isolation makes it easier to identify the cause without introducing a second problem.

Number formats can hide digits. Here is why Excel only shows two decimal places.

What each Format Cells tab does

Tab Use it to
Number Show values as currency, percentages, dates, times, fractions, text, or a custom format
Alignment Align text, wrap it, merge cells, indent, or rotate text
Font Change the font, size, color, bold, italic, and underline
Border Add lines around or inside the selected cells
Fill Add a background color or pattern
Protection Lock or hide cells (this only takes effect after you protect the sheet)

Handy formatting shortcuts

Shortcut (Windows) Result
Ctrl+1 Open Format Cells
Ctrl+Shift+$ Currency with two decimal places
Ctrl+Shift+% Percentage with no decimals
Ctrl+Shift+# Date with day, month, and year
Ctrl+Shift+! Number with two decimals and a thousands separator
Ctrl+B / Ctrl+I / Ctrl+U Bold, italic, underline

Custom number formats

In Format Cells, choose Number > Custom and type a code in the Type box. A few common ones:

  • #,##0 shows whole numbers with thousands separators, such as 12,500.
  • 0.00 always shows two decimal places.
  • 0.0% shows a percentage with one decimal place.

Why does my number show as ####?

The column is too narrow to display the formatted value. Double-click the right edge of the column header to widen it.

Copy and clear formatting

  • Format Painter. Click a formatted cell, click Format Painter on the Home tab, then click or drag over the cells you want to match. Double-click Format Painter to apply it to several ranges.
  • Clear Formats. Select the cells and choose Home > Clear > Clear Formats to remove formatting but keep the values.

Related: Capitalize the first letter of each word in Excel.

Related: Remove temporary Sheet Views in Excel.

Related: Select multiple items from an Excel dropdown list.

Applying the Text format after a value has already changed cannot undo a date conversion, as explained in stopping Excel from converting entries to dates.

The Alignment tab in the same dialog can also center a title across several cells without merging them.