How to Create a Dotted Underline in Excel 'dotted underline in excel'

When working with text in Microsoft Excel, it's not uncommon to need to add an underline to specific words or phrases. In this article, we'll explore how to create a dotted underline in Excel and provide some helpful tips along the way.

To start, open your Excel spreadsheet and select the text you want to underline. Right-click on the selected text and choose 'Format Cells' from the drop-down menu. This will open the Format Cells dialog box.

In the Font tab of the dialog box, click on the 'Font Size' control and specify a size of 2 points. You may wonder what to do about the leading space at this point. To make it virtually disappear, follow these steps:

* If you had selected the anchoring space in step 4, then this approach would not have worked. Instead, all you did was raise the other text higher away from the baseline.

* This works because the underline is 'keyed' to the leading space, which did not get raised.

By adjusting the font size and leading space, you should be able to create a dotted underline that completely clears the descenders on your text. Some trial and error may be needed to find the perfect setting, as it will depend on the size of the font you're using for your text.

In addition to adjusting the font size and leading space, you can also use the 'By' field in the Format Cells dialog box to specify how much you want the text raised vertically. Simply choose a value from the drop-down list next to the Position control.

Finally, make sure to select all of the text you just underlined, including any leading spaces, and then apply the underline style using the Advanced tab of the dialog box.

With these steps, you should be able to create a dotted underline in Excel that perfectly complements your text. Happy formatting!

Dotted underline in excel