how to underline in excel without using border

So, if you want to underline text and modify it's thickness also, you can ' border-bottom' CSS property, which allows us to modify thickness of underline also. One of the drawbacks of using text-decoration is you can not change thickness of underline. In the above examples, we are using all ways to underline text using CSS, using text-decoration short hand property or using text-decoration-line property. The text-decoration property specifies the decoration added to text, and is a shorthand property for: One more Using CSS but this time overline also. One more Using CSS text-decoration-line. One more Using CSS text-decoration complete This is underlined using CSS text-decoration On the Mac, this shortcut works directly on the worksheet, and adds a bottom border to each cell in the selection. Please follow these steps to make the text or value of the cell as double underline. cell.SetStyle(st) Excel Cell Formatting Double Underline. st.Font.Underline FontUnderlineType.Single // Set the style of cell. If you use this shortcut in Format Cells, youll see a bottom border added or removed from the border preview area. Style st cell.GetStyle() // Set the font underline. Underline Text using CSSĪs mentioned, above we have better way to underline text which is done using CSS's 'text-decoration' property, which gives more control over underline styling, color etc. On Windows, this shortcut only works within the Format Cells dialog box, on the Borders tab. You can change color of underline, using CSS you can also change style of underline. When you use the AutoFill handle to replicate the formula in cell C3 down through range C4 to C11, a little. In the example shown here, the worksheet was already formatted with a border around the table. Why?īecause using CSS, you can have better control over this underlined text. When you use the AutoFill handle in Excel, as well as copying your formula it also copies your formatting. Now, as you see this is very simple approach to underline the text, but I think it would be much better to use CSS. You can simply use tag in HTML to underline the text. Let's take a look at both ways, with examples, one by one. Excels border tool can apply a variety of borders, but is a bit tricky to get started with. Borders help to segment your data and wall it off from other sections of data in your spreadsheet. We can create Underlined text in HTML in two ways The combination of bold, italic, and underline text makes this example spreadsheet easier to read. For this, you will go through right click > format cells (CTRL+1) approach only. CATCH This will not allow you to do accounting single / double underlining. Click the small arrow next to U to expose option to insert double underline.

But we should use underline text with caution, as generally underlined text in websites are links. You can go to Home tab > Click on Underline U to insert single underline. Using Underlines below text, we can bring attention of our readers.

In this article, we will providing you an example to create text with underline using HTML and CSS and using plain HTML also.

How to underline in excel without using border