sodcalculator

10 Tech How-To

Excel Underline Options: A Step-by-Step Guide

Guide 10-43562 · Updated · Step by step

This guide shows you how to apply and customize underlines in Microsoft Excel, from the basic single underline to double, accounting, and even partial underlines within a cell. You’ll learn the exact menu paths and keyboard shortcuts for each option, along with tips to avoid common formatting pitfalls.

What You’ll Need

  • Microsoft Excel (2013 or later; steps are similar across versions)
  • A worksheet with text or numbers you want to underline
  • Basic familiarity with selecting cells and using the ribbon

Step-by-Step

  1. Select the cell or range – Click and drag to highlight the cells you want to format. For a single cell, just click it. To select non-adjacent cells, hold Ctrl while clicking.
  2. Open the Format Cells dialog – Right-click the selected area and choose Format Cells, or press Ctrl+1. This dialog gives you access to all underline styles.
  3. Go to the Font tab – It’s the first tab in the dialog. Look for the Underline drop-down menu near the middle of the dialog.
  4. Choose your underline style – Click the drop-down and select one of these:
    • None – Removes any existing underline.
    • Single – A standard thin line under the entire cell content.
    • Double – Two thin lines, often used for totals or emphasis.
    • Single Accounting – A line that spans the full width of the cell, not just the text. This is the style Excel uses for financial statements.
    • Double Accounting – Two full-width lines, also for financial statements.
  5. Apply the formatting – Click OK. The underline appears immediately in your selected cells.
  6. For a quick single underline – Skip the dialog and use the ribbon: on the Home tab, in the Font group, click the U icon. This toggles a single underline on and off.
  7. For a quick double underline – Use the keyboard shortcut Ctrl+Shift+D. This applies a double underline directly, no dialog needed.
  8. To underline only part of a cell – Double-click the cell (or press F2) to enter edit mode. Select just the characters you want underlined, then press Ctrl+U or use the ribbon’s U button.
  9. To remove an underline – Select the cells, open Format Cells (Ctrl+1), choose None from the Underline drop-down, and click OK. Alternatively, press Ctrl+U to toggle off a single underline.

Common Mistakes

  • Underlining the entire cell instead of the text – The regular “Single” underline only goes under the text. If you want a line that spans the full cell width, use “Single Accounting.”
  • Forgetting to select the exact characters – When underlining part of a cell, if you select the whole cell (not just the text), you’ll underline everything. Double-click first to enter edit mode.
  • Using the border tool instead – The border icon (a square with a line at the bottom) adds a bottom border to the cell, which looks similar but behaves differently. Borders don’t move with the text when you sort or filter, and they don’t appear in the Font formatting options.
  • Applying underline to merged cells – If you merge cells and then underline, the line may not span the entire merged area as expected. Test with a small range first.

Tips

  • Use Accounting underlines for financial data – They align with the cell’s width, making columns look cleaner when you have numbers of varying lengths.
  • Create a custom style – If you frequently use a specific underline (like Double Accounting), go to Home > Cell Styles > New Cell Style, set the formatting, and give it a name. Then apply it with one click.
  • Keyboard shortcut for the dialog – Press Ctrl+1 to open Format Cells, then Alt+U to jump to the Underline drop-down. This saves mouse clicks.
  • Underline in formulas – You can underline the result of a formula, but the underline applies to the cell, not the formula itself. To underline just part of a formula’s output, you’d need to split the result into multiple cells.
  • Check print preview – Underlines may look different when printed, especially if you have gridlines enabled. Use File > Print to preview before printing.

Troubleshooting

The underline doesn’t appear – Make sure you’ve selected the correct cells. If you’re in edit mode (double-clicked a cell), the underline applies only to the selected characters, not the whole cell. Exit edit mode by pressing Enter or Esc.

The underline is too thick or too thin – Excel doesn’t offer adjustable thickness for underlines. If you need a thicker line, consider using a bottom border with a thicker weight instead. Select the cells, go to Home > Borders > More Borders, choose a line style and weight, and apply to the bottom.

Underline disappears when I type over the cell – This happens if you’re in edit mode and only underlined part of the text. When you type new characters, the underline doesn’t extend to them automatically. Re-apply the underline to the new text, or format the entire cell.

Shortcut Ctrl+U doesn’t work – Check if you have any add-ins or keyboard layouts that override shortcuts. Try using the ribbon’s U button instead. Also, ensure you’re not in edit mode (the shortcut toggles underline for the whole cell only when not editing).

Accounting underline doesn’t span the full cell – The Accounting style underlines the entire cell width by default. If it’s not doing that, you may have applied a regular underline by mistake. Re-open Format Cells and select “Single Accounting” or “Double Accounting” explicitly.

Frequently Asked Questions

Can I underline text in a cell without underlining the whole cell?

Yes. Double-click the cell to enter edit mode, select the specific characters with your mouse or keyboard, then apply the underline. Only the selected characters will be underlined.

What’s the difference between “Single” and “Single Accounting” underline?

“Single” underlines only the text content, while “Single Accounting” underlines the entire width of the cell, regardless of how much text is present. Accounting is typically used for financial statements to align underlines across columns.

How do I remove an underline from a cell?

Select the cell(s), press Ctrl+1 to open Format Cells, choose “None” from the Underline drop-down, and click OK. Or, if it’s a single underline, just press Ctrl+U to toggle it off.

Can I use a double underline as a subtotal or total separator?

Yes, double underlines are commonly used to indicate totals in accounting and financial reports. Use the keyboard shortcut Ctrl+Shift+D for a quick double underline.

Why does my underline not show when I print?

Check your print settings. If you have “Gridlines” enabled in Page Setup, the gridlines might obscure the underline. Go to Page Layout > Sheet Options and uncheck “Print” under Gridlines. Also, ensure the cells aren’t set to a white font color that makes the underline invisible on screen.

Can I apply different underline styles to different parts of the same cell?

No, Excel only allows one underline style per cell, or per selected range of characters. If you need multiple styles, you’d have to split the content into separate cells or use borders creatively.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →