To see how a cell is formatted in Excel, select it and press Ctrl + 1. The Format Cells dialog opens, and its tabs show the number format, alignment, font, borders, fill and protection settings on that cell. If a color or icon appears only when the value meets a condition, check Home > Conditional Formatting > Manage Rules instead.
The steps below are for the Excel desktop app on Windows (Excel for Microsoft 365, Excel 2024 and Excel 2021, which share the same ribbon labels). Excel for the web has its own short section near the end.
Where Each Kind of Formatting Shows Up
A cell’s appearance can come from several layers at once: formatting you applied by hand, a number format, a cell style, a table style and conditional formatting rules that switch on when a value changes. Microsoft’s Excel help does not describe one panel that lists all of these together, so the practical approach is to know which tool answers which question.
| What you want to know | Where to look |
|---|---|
| Number format (date, currency, percent, text) | Number Format box on the Home tab, or Ctrl + 1 > Number |
| Font, size, color, bold, strikethrough | Ctrl + 1 > Font |
| Wrap text, merged cells, text angle, indent | Ctrl + 1 > Alignment |
| Cell borders and line styles | Ctrl + 1 > Border |
| Background color or pattern | Ctrl + 1 > Fill |
| Locked and Hidden settings | Ctrl + 1 > Protection |
| Color that changes with the value | Home > Conditional Formatting > Manage Rules |
| Which cells have rules or validation | Find & Select > Go To Special |
| Formulas instead of results | Ctrl + ` or Formulas > Show Formulas |
| Every cell that shares a format | Find (Ctrl + F) > Options > Format |
Check One Cell With the Format Cells Dialog
The Format Cells dialog is the most complete readout of a cell’s own formatting. It works best on one cell at a time, because a range with mixed settings is harder to read.
- Click the cell you want to inspect.
- Press Ctrl + 1. You can also right-click the cell and choose Format Cells. The Format Cells dialog opens.
- Select the Number tab. The highlighted entry in the Category list is the cell’s number format, and the Sample box shows how the current value looks in that format.
- Select the Alignment tab to see horizontal and vertical alignment, indent, text orientation and whether Wrap text, Shrink to fit or Merge cells is checked.
- Select the Font tab to see the font name, style, size, underline, color and effects such as Strikethrough, Superscript and Subscript.
- Select the Border tab. The preview shows which edges have a border, along with the line style and color.
- Select the Fill tab to see the Background Color and any Pattern Color or Pattern Style.
- Select the Protection tab to see whether Locked and Hidden are checked.
- Select Cancel to close the dialog without changing anything.


Two details on these tabs confuse many people. First, Locked is on for every cell by default, and neither Locked nor Hidden does anything until the worksheet itself is protected, as Microsoft explains in its guide to the Format Cells dialog settings. Second, a cell with General in the Category list has no special number format: Excel shows what you typed, rounding long decimals if the column is too narrow.
Read the Number Format Without Opening a Dialog
For a quick check of the number format alone, click the cell and look at the Number Format box in the Number group on the Home tab. It shows the format name, such as General, Currency, Date or Percentage. Open its drop-down to see the other common formats, or select the small dialog launcher arrow at the bottom right of the Number group to jump straight to the Number tab of Format Cells.
Compare what the cell shows with what the formula bar shows. A number format changes only the display. Microsoft’s example is a cell that shows 1.23 while Excel still calculates with 1.2345. Likewise, a cell formatted as Percentage that shows 15% holds 0.15. When a total looks off by a cent, the hidden decimals are usually the reason. If you want to apply a currency format rather than inspect one, see how to add a dollar sign to numbers automatically in Excel.
See Conditional Formatting Rules
Conditional formatting is formatting that Excel applies only while a rule is true, such as “color the cell red when the value is below 0”. This is the layer most often missed, because a rule’s color does not show on the Fill tab of Format Cells.
- Click a cell that shows the color, icon or data bar you are curious about.
- On the Home tab, in the Styles group, select the arrow next to Conditional Formatting.
- Select Manage Rules. The Conditional Formatting Rules Manager opens.
- Read the list. For each rule you see the rule itself, a preview of its format, the range in the Applies to box and the Stop If True setting.
- If the list is empty or seems incomplete, open the Show formatting rules for list at the top and switch from the current selection to the whole worksheet. Rules that cover other parts of the sheet now appear.
- To read a rule in full, select it and choose Edit Rule. Select Cancel when you are done looking.


Rule order matters. When two rules conflict on the same cell, the rule higher in the list wins, and Stop If True stops Excel from checking rules below it. Microsoft covers precedence, Move Up and Move Down in its page on managing conditional formatting rule precedence.
To see which cells carry any rule at all, select Home > Find & Select > Conditional Formatting. Excel selects every cell on the sheet that has a conditional formatting rule, which helps when a sheet was built by someone else.
Locate Cells With Go To Special
Go To Special selects cells by what they contain or what is applied to them. It does not describe the formatting, but it shows you where it is.
- Click a single cell to search the whole sheet, or select a range to search only that range.
- On the Home tab, select Find & Select > Go To, or press Ctrl + G.
- Select Special.
- Choose an option and select OK. Excel highlights the matching cells.

The options that help most with formatting questions:
- Conditional formats selects cells that have conditional formatting. Choose All for every such cell, or Same for cells with the same rules as the active cell.
- Data validation selects cells that have validation rules (drop-down lists and entry limits). All and Same work the same way.
- Constants selects cells with typed values, and Formulas selects cells with formulas. The check boxes under Formulas narrow the search to numbers, text, logical values or errors.
A practical use: in a column that should be all formulas, select the column and choose Constants. Any number someone typed over a formula is selected, even if it is formatted to look identical to its neighbors. Microsoft lists every option in Find and select cells that meet specific conditions.
Show Formulas Instead of Results
Sometimes “what is this cell doing” is really a question about the formula, not the format. Press Ctrl + ` (the grave accent key, to the left of 1 on US keyboards), or select Formulas > Show Formulas. Every cell now shows its formula instead of the result, which makes typed values and calculated values easy to tell apart. Press the same shortcut again to switch back. Microsoft documents both routes on Display or hide formulas.
This view is also a quick way to find error handlers. A cell that shows 0 might hold a plain 0 or a formula such as one that displays 0 instead of #N/A, and Show Formulas reveals which.
Find Every Cell That Shares a Format
Find and Replace can search by format instead of text, which answers “where else is this formatting used?”
- Press Ctrl + F, or select Home > Find & Select > Find.
- Select Options to expand the dialog.
- Clear anything in the Find what box.
- Select the arrow next to Format, then choose Choose Format From Cell.
- Click a cell that has the formatting you want to match.
- In the Within list, choose Sheet or Workbook.
- Select Find All. A list of matching cells appears at the bottom of the dialog. Click an entry to jump to that cell.

Microsoft’s steps are on Find or replace text and numbers on a worksheet.
Check Cell Styles and Themes
A cell style is a named bundle of formatting, such as fonts, number formats, borders and shading, applied in one click. The gallery lives at Home > Styles > Cell Styles. To see exactly what a style contains, right-click it in the gallery and choose Modify; the Style Includes list shows each part. Selecting Normal under Good, Bad and Neutral removes a style from the selected cells without deleting the style.
Microsoft’s help does not describe a readout that names the style on a selected cell, so the Format Cells tabs remain the reliable check of what the cell actually looks like. Keep in mind that some styles follow the workbook theme, so a cell’s colors and fonts can change when someone picks a different workbook theme.
Tools That Do Not Show Formatting
Two features often get described as ways to see formatting. Neither does that job.

Format Painter (Home > Format Painter, the paintbrush icon) copies formatting from one cell and applies it to another. It is useful once you have found a format you want to reuse, but it does not display or list anything. Painting onto the wrong cells overwrites their formatting, so press Ctrl + Z right away if that happens. The tool works the same way in Word, as shown in this walkthrough on copying a color in Word with Format Painter.
The status bar at the bottom of the window shows calculations for the selected cells, such as average, count and sum. It says nothing about formatting. It is still handy for one check: if you select a column of “numbers” and the sum is missing or smaller than expected, some of those cells may be text that only looks like numbers.
Excel for the Web
Excel for the web displays cell and number formatting in the browser much as the desktop app does. Ctrl + 1 opens the formatting window in the browser as well, and the status bar shows average, count and sum for selected numbers.
The Go To Special, Find by format and Show Formulas steps above come from Microsoft pages written for the desktop app. If a command is missing or behaves differently in your browser, open the workbook in the Excel desktop app to inspect it, then return to the browser.
Remove or Reset Formatting
Once you know where unwanted formatting comes from, remove it from the source:
- Manual formatting: select the cells, then go to Home > Clear (in the Editing group) > Clear Formats. Microsoft’s page on clearing cells of contents or formats lists number formats, conditional formats and borders among the formats a cell can hold. Clear Contents removes only values and keeps the formatting; Clear All removes both, plus comments.
- Background color only: Home > Fill Color arrow > No Fill.
- A cell style: Home > Cell Styles > Normal.
- One conditional formatting rule: open Manage Rules, select the rule, use the delete button for the selected rule, then select OK.
If you clear too much, press Ctrl + Z to undo.
Troubleshooting Formatting You Cannot Explain
The cell is colored but the Fill tab shows no color. The color almost certainly comes from a conditional formatting rule or a table style. Check Manage Rules first. If the range was formatted as a table, banded row colors come from the table style rather than from the cell.
Numbers will not add up. The cells may hold text. Click one and check whether the Number Format box says Text.
Format Cells is unavailable. The worksheet is probably protected, and protection can block formatting changes. Ask the person who protected it to unprotect the sheet or share the password.
You need a report of formatting across many sheets. Microsoft’s help does not describe a built-in formatting report. A recorded or written VBA macro can loop through cells and list their formats, but Excel keeps macros off until you allow macros in Excel for that workbook, so only run code you trust.
Questions About Viewing Excel Formatting
Is there a keyboard shortcut that shows all of a cell’s formatting?
Not one that covers every layer. Ctrl + 1 shows the cell’s own formatting in Format Cells. Conditional formatting rules need Manage Rules, and Ctrl + ` shows formulas rather than formatting.
Does the formula bar show formatting?
No. The formula bar shows the value or formula stored in the cell. That makes it useful next to the Number Format box: the cell shows the formatted value, and the formula bar shows what Excel calculates with.
How can I tell if a cell has conditional formatting?
Select Home > Find & Select > Conditional Formatting. Every cell with a rule is selected. Then open Manage Rules with one of those cells selected to read the rule.
Can I see the formatting of a whole range at once?
You can select a range before pressing Ctrl + 1, but settings that differ between cells will not show clearly. For a range, it is faster to use Find with Format to see which cells match a given cell, or Go To Special to see where rules and validation are applied.
Why does printing show colors I do not see in the formatting?
Printed colors still come from the same layers: cell fill, table styles and conditional formatting. If a printout surprises you in other ways, such as missing columns, the cause is usually page setup, covered in why an entire Excel spreadsheet does not print.