Excel Formatting Keyboard Shortcuts: A Practical Guide

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, Ctrl+1 opens Format Cells, while Ctrl+B, Ctrl+I, and Ctrl+U apply bold, italic, and underline. For common number formats, use shortcuts such as Ctrl+Shift+% for percentages and Ctrl+Shift+$ for currency; the ribbon also has keyboard access keys for fills, borders, and sizing.

How Excel formatting shortcuts work

Excel shortcuts either apply a formatting command immediately or open a control where you can choose settings. Ctrl+B, for example, toggles bold for the selected cell or text; Ctrl+1 opens a dialog with detailed choices for number display, alignment, font, borders, and fill. Ribbon access keys are different: press and release Alt, then follow the letters shown on the ribbon. They are sequential key presses, not a combination to hold down together.

Formatting changes how a value looks, not necessarily what is stored in the cell. A date can be displayed as 3-Nov-2026 while remaining a date serial value that Excel can use in calculations. Similarly, a percentage format can display 0.25 as 25%, without changing the underlying value to 25. This distinction helps explain why formatting can change a display without changing a calculation.

  • Select a cell or range before applying a shortcut to format more than one cell.
  • For text inside a cell, enter edit mode first, select the characters, and then apply a text style.
  • If a shortcut does not work as expected, check the active selection and whether Excel or another app has focus.

Shortcuts for bold, italic, and other text styles

For everyday text formatting, these Windows shortcuts work on the current selection:

  • Ctrl+B: toggle bold.
  • Ctrl+I: toggle italic.
  • Ctrl+U: toggle underline.
  • Ctrl+5: toggle strikethrough.

These are toggles: applying the same command again removes the style. They also work on selected characters while editing a cell, rather than only on the whole cell. To edit a cell, press F2 or double-click it, select the characters, and use the style shortcut. If the cell is not in edit mode, Excel applies formatting to the cell’s contents as a whole.

These commands are useful for a brief emphasis, but use them consistently. For example, bolding column headings and totals can make a table easier to scan; bolding many unrelated values makes the visual hierarchy less clear. Ctrl+1 gives access to additional font options, including font size and effects, which do not all have a dedicated universal shortcut.

Number-format shortcuts for dates, percentages, and currency

Number formats control how Excel displays numeric values. On Windows, select the cells and use one of these shortcuts:

  • Ctrl+Shift+~: General format.
  • Ctrl+Shift+!: Number format with two decimal places, a thousands separator, and a minus sign for negative values.
  • Ctrl+Shift+$: Currency format with two decimal places.
  • Ctrl+Shift+%: Percentage format with no decimal places.
  • Ctrl+Shift+^: Scientific format with two decimal places.
  • Ctrl+Shift+#: Date format displayed as day, abbreviated month, and year.
  • Ctrl+Shift+@: Time format.

These formats affect display, so choose one that suits the data. If a cell contains 0.075, applying percentage format displays 8% because the standard shortcut uses zero decimal places and Excel rounds the display. The stored value remains 0.075. To show 7.5%, increase the displayed decimal places with the Home ribbon’s number controls or open Format Cells with Ctrl+1 and choose Percentage with one decimal place.

Currency and date displays can depend on regional settings. The currency symbol may follow the selected locale, and date order may differ between regions. If the shortcut’s result is not the format you need, use Ctrl+1 and inspect the Number tab. Avoid typing a symbol or apostrophe merely to make a value look formatted: that can turn a numeric value into text and interfere with sorting or calculations.

Alignment, wrapping, and cell sizing

Alignment shortcuts can make a sheet easier to read, but several common alignment commands are fastest through ribbon access keys. On Windows, press Alt, then H, then A to open the Home tab’s alignment options. The KeyTips shown on screen guide you to commands such as horizontal alignment and text wrapping; the final keys can depend on the displayed KeyTips.

For common sizing tasks, these access-key sequences are useful in desktop Excel for Windows:

  • Alt, H, O, I: AutoFit the selected column width to its contents.
  • Alt, H, O, A: AutoFit the selected row height.
  • Alt, H, O, W: open the Column Width command.
  • Alt, H, O, H: open the Row Height command.

For example, select column B and use the AutoFit column sequence to size it to the longest visible entry. If a long heading should remain within a fixed-width column, use Wrap Text instead; AutoFit is not always the best choice because a long value can make the column excessively wide. Merged cells can also complicate AutoFit, so check the result and adjust the size manually when necessary.

Fill colors, font colors, and borders

Excel does not give every color or border choice its own easy-to-remember Ctrl shortcut. On Windows, use Alt, H, H to open the Fill Color menu, and Alt, H, FC to open the Font Color menu. The menu lets you choose a color; the exact KeyTips are visible as you move through the ribbon. For borders, Alt, H, B opens the Home tab’s Borders menu, where you can pick a border type.

There are also direct Windows shortcuts for a couple of border actions: Ctrl+Shift+& applies an outline border to the selected cells, and Ctrl+Shift+_ removes the outline border. These are not substitutes for the full Borders menu, which offers more control over individual edges, line styles, and colors. If you need a specific combination, Ctrl+1 opens the Format Cells dialog, where the Border tab provides those settings.

Use color to communicate meaning consistently. For instance, a fill color might distinguish input cells from calculated cells, but color alone is not a reliable signal for every reader. A short label, clear heading, or border can provide additional context. To remove a fill, open the Fill Color menu and choose No Fill; changing the font color back to Automatic is different and does not clear the cell’s background.

A practical formatting sequence

Suppose a small sales table has headings in row 1, dates in column A, amounts in column B, and a total in B12. A useful sequence is to format the data deliberately rather than apply a single style to the whole sheet:

  1. Select the heading cells and press Ctrl+B to make them bold.
  2. Select the date cells and press Ctrl+Shift+#, then check that the resulting date order is appropriate for the workbook’s region.
  3. Select the amount cells and press Ctrl+Shift+$ for a currency display, or Ctrl+Shift+! if a currency symbol is not wanted.
  4. Select B12 and press Ctrl+B to distinguish the total, then use the Borders menu if a top border would make the summary clearer.
  5. Select the relevant columns and AutoFit them with Alt, H, O, I; widen or wrap any heading that becomes awkward.

This approach keeps the value type and its display in view. If a date shortcut produces a number rather than a date, the cell may contain text rather than a real date, or the selection may not be what you intended. If a currency shortcut appears to do nothing, verify that the selected cell is numeric. Formatting does not convert text into a number or repair an invalid date entry.

Windows, Mac, and Excel for the web

This guide’s Alt-based sequences and Ctrl shortcuts are for desktop Excel on Windows. In Excel for Mac, common text shortcuts use Command instead: Command+B for bold, Command+I for italic, and Command+U for underline. Command+1 opens Format Cells. Some number-format shortcuts use Control rather than Command on Mac, and available key combinations can depend on the keyboard layout and macOS settings. If a combination conflicts with a system shortcut, use the Format Cells dialog or the ribbon instead.

Excel for the web runs in a browser, where browser shortcuts and Excel shortcuts can overlap. Some desktop ribbon access-key sequences may not behave the same way, and available commands can vary with the browser and interface. Use the ribbon’s Home tab for formatting or open the web app’s shortcut help if a desktop shortcut is intercepted. If exact desktop keyboard behavior is important, use the Excel desktop app.

Common shortcut problems and misconceptions

A frequent source of confusion is applying a shortcut to the wrong selection. Clicking a cell formats that cell; selecting a range formats the range. In edit mode, however, a text-style shortcut can affect selected characters. Press Esc to leave an unintended selection or edit operation, then check the cell outline before trying again.

Another misconception is that number formatting changes the value. A displayed 25% may represent 0.25, and a date display may represent a serial number. If you need to change the underlying value, edit the entry or use a formula; changing the format alone will not do it. Also note that a shortcut can appear to have no effect when the cell already has that style, when the data is text, or when a protected sheet restricts formatting.

Finally, not every ribbon command has a single-letter shortcut, and access keys may vary as Microsoft updates the ribbon. Press Alt and follow the visible KeyTips rather than guessing a sequence. Ctrl+1 is often the most dependable route when a command is hard to locate because its tabs group detailed formatting options in one dialog.

Frequently Asked Questions

What is the shortcut to format cells in Excel?
In Excel for Windows, press Ctrl+1 to open the Format Cells dialog. On Mac, use Command+1. Choose a number format, alignment, font, border, or fill option in the dialog.

How do I make text bold, italic, or underlined?
Select the cell or text and press Ctrl+B for bold, Ctrl+I for italic, or Ctrl+U for underline on Windows. On Mac, use Command with B, I, or U.

What shortcut changes a cell to percentage format?
Select the numeric cells and press Ctrl+Shift+% on Windows. It displays the value as a percentage with no decimal places; the underlying value does not change.

Can I use a shortcut to change cell fill color?
On Windows, Alt, H, H opens the Fill Color menu. Choose a swatch from the menu, or use the Home ribbon if you need to inspect the available colors.

Why did my date or currency shortcut show an unexpected result?
The shortcut applies a display format, not a data conversion. Check that the cell contains a real numeric value or date, and use Ctrl+1 to review the format and regional display settings.

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.