Format Text in Excel Cells: Fonts, Color & Style

A student in one of my workshops, this was early 2026, spent twenty minutes trying to make her header row stand out. She kept changing the background color, then the font, then undoing everything because nothing looked right. The problem wasn't her taste. She'd been formatting the cells before selecting the text inside them, so half her changes weren't sticking. One small misunderstanding, fifteen wasted minutes.

If you're here to learn how to format text in Excel cells (font, size, color, bold, alignment, all of that), you're in the right place. Quick note before we start: there's also something called the TEXT function in Excel, which converts numbers into formatted strings. That's a different tool for a different job. This article covers cell formatting, not that function. By the end, you'll know how to style entire cells, format individual characters inside a cell, and use the Format Cells dialog box to handle alignment and wrap text.

---

What You'll Be Able to Do, and the One Format Text in Excel Confusion to Clear Up First

By the time you finish reading, you'll be able to change font face, size, and color across a cell range; format a single word or character inside a cell without touching the rest; and control text alignment and wrapping through the Format Cells dialog box. These three skills cover probably 90% of what people actually need for everyday spreadsheet work in Microsoft Excel.

The confusion worth naming upfront: searching "format text excel" pulls up two totally different topics, visual cell formatting (what we're doing here) and the TEXT() function, which is for converting numbers into text strings. They share a name and almost nothing else. If you landed here looking for TEXT() format codes, Excel number formatting is probably closer to what you need. Otherwise, let's get into it.

---

Step 1: Apply Font Formatting in Excel Using the Home Tab (Fastest Method)

Select your cell or range first. Always. This is the step people skip when they're moving fast, and it's exactly why formatting sometimes seems to do nothing: you're styling an empty selection or the wrong group of cells. Click the cell, or click and drag across a range, and then go to the ribbon.

Change Font, Size, and Color from the Ribbon

The Home tab in the Excel ribbon has a Font group, the cluster of controls that shows the font name dropdown, a size box, and a row of style buttons. Click the font name dropdown to swap typefaces. Click the size box and type a number, or use the small A buttons to nudge the size up or down. For color, click the small arrow next to the A with the colored underline. That opens a color picker where you can choose a theme color or enter a custom hex value if you're working with branded colors.

This works identically in Microsoft 365, both the desktop app and Excel Online, though the color picker in the browser version is slightly simplified.

Apply Bold, Italic, and Underline with Keyboard Shortcuts

The shortcuts here are worth memorizing because they're the same across almost every Microsoft Office app. Ctrl+B toggles bold, Ctrl+I toggles italic, Ctrl+U toggles underline. On a Mac, swap Ctrl for Cmd. These are the bold, italic, underline Excel shortcuts you'll use constantly once they're muscle memory. I probably use Ctrl+B fifty times a day without thinking about it.

---

Step 2: Format Only Part of the Text Inside a Cell (What Most Guides Skip)

Once you've got whole-cell formatting down, there's a more precise move worth knowing. Most tutorials never mention it: you can format individual characters or words inside a single cell without changing the rest of the cell's text. This only works on cells that contain plain text values, not formula results. If a cell is displaying the output of a formula, this approach won't work.

Select Specific Characters in the Formula Bar

1. Double-click the cell to enter edit mode, or click the cell once and then click into the formula bar at the top.
2. Click and drag to highlight just the characters you want to format: one word, a single number, whatever.
3. With those characters selected, go to the Home tab Font group and apply your formatting normally. Bold, color, font size, all of it applies only to what you've selected.

You can also do this entirely in the formula bar if you prefer. Some people find it easier to select text there because the cursor behaves more like a word processor. Either way works. This is one of those features that feels obvious once you know it and completely invisible before.

---

Step 3: Use the Format Cells Dialog Box to Control Alignment, Wrap Text, and More

The Home tab covers the basics, but the Format Cells dialog box is where you get the full picture. Think of the ribbon as the quick-access panel and the dialog box as the settings menu. You'll want the dialog box when you need text alignment, wrap text, or anything the ribbon doesn't surface directly.

Open Format Cells with Ctrl+1

Select your cell or range, then press Ctrl+1. That's the shortcut, no menu-digging required. The Format Cells dialog opens with several tabs across the top: Number, Alignment, Font, Border, Fill, Protection. For text formatting, you'll mostly use Font and Alignment. The Font tab here gives you every option the ribbon does, plus a few more like strikethrough and double-underline that don't have ribbon buttons.

Set Text Alignment and Enable Wrap Text

Click the Alignment tab. Here you can set horizontal alignment (Left, Center, Right, and the less-obvious Fill and Justify options), vertical alignment (useful when your row height is taller than the text), and text direction for language or design reasons.

The Wrap Text checkbox is the one you'll want when your text spills into the neighboring cell and you'd rather it stay inside its own column. Check it, and Excel expands the row height to show all the text within the cell's width. No more text bleeding across columns.

Avoid using Merge Cells for visual centering across columns if your data needs to be filtered or sorted later. Merged cells break both features. Use "Center Across Selection" from this same Alignment tab instead, it looks identical on screen but doesn't actually merge the cells.

---

Common Mistakes When You Format Text in Excel, and How to Fix Them Fast

The most common one: formatting a cell before you've typed anything into it, or clicking the wrong cell entirely. The fix is simple, always confirm your selection before reaching for any formatting control. Glance at the cell reference box in the top-left corner of the screen if you're not sure what's selected.

The second mistake catches people who've heard about the TEXT function and assume it's the right tool for making data look nicer. It's not, not always. The TEXT function converts a number into a text string, which means Excel can no longer use that value in calculations. If you apply TEXT() to a revenue figure so it shows with a dollar sign, that cell is now text. You can't sum it. Use cell formatting instead whenever you want something to look formatted without losing its numeric value. Reserve TEXT() for cases where you actually need to combine a formatted number with other text in a single cell.

Third: if you're using date format codes and your dates look wrong, check your locale. The code mm/dd/yyyy is standard in the US; most other countries expect dd/mm/yyyy. Excel pulls from your system's regional settings by default, but format codes don't auto-adjust. A mismatched format code will display the wrong date, or throw an error, without any obvious warning.

If you're newer to spreadsheets and building up from the basics, the Excel for Beginners starter guide covers the foundational concepts that make all of this click faster.

---