Underline cell contents, entire cells, or rows on a worksheet

There are several ways to add underlining to data on a worksheet. You can underline all or selected text in cells, apply a bottom border to cells or rows, or draw a line to underline cells.

  1. Do one of the following:

    • To underline all text or numbers in a cell or range of cells, select that cell or range of cells.

    • To underline just a portion of the contents in a cell, double-click that cell, and then select the text or numbers that you want to underline.

      If editing in a cell is turned on, you can select the cell contents by double-clicking the cell. If editing in a cell is turned off, you can click the cell and then select the text or numbers that you want to underline in the formula bar. You can also press F2 to edit the active cell, use the arrow keys to place the insertion point, and then use SHIFT+arrow keys to select the contents.

  2. On the Home tab, in the Font group, do one of the following:

    • To apply a single underline, click Underline Button image .

    • To apply a different style of underline, such as a double underline or a single or double accounting underline (an underline that fills the width of a cell), click the Dialog Box Launcher Button image next to Font and then, in the Underline box, click the style that you want to use.

      Excel Ribbon Image

  1. Select the cell, range of cells, or rows that you want to underline. For more information, see Select cells, ranges, rows, or columns o\n a worksheet.

  2. On the Home tab, in the Font group, click the arrow next to Bottom Border Button image , and then click a bottom border style on the palette.

    Excel Ribbon Image

  1. On the Insert tab, in the Illustrations group, click Shapes.

    The Illustrations group on the Insert tab

  2. Under Lines, click Button image .

  3. Drag to draw a line underneath the cells that you want to underline.

    To draw a perfectly straight line, hold down SHIFT while you drag to draw the line.

  4. To change the formatting of the line, click the line to select it.

    This displays the Drawing Tools, adding the Format tab.

  5. On the Format tab, in the Shape Styles group, select the formatting options that you want.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×