Double Underline

Google Sheets – Create a double underline bottom border

Lots of spreadsheet users can’t imagine life without their double underline feature. There has been much gnashing of teeth for those making the switch to Google Sheets when they find that their faithful double underline function is not there. This is one of the few ways in which Sheets is inferior to Excel. What is one to do? Before you abandon ship, you should realize that there are a few decent work arounds for the issues. None of them are perfect, but you should be able to get the effect that you are looking for.

Update – As of late February 2017, a double underline is available in Google sheets without needing to use any workarounds.

Double Underline
Double underline option

The remainder of this article is preserved just in case you want to know how hard we had it way back when!

Bottom border and underline

The first option is to use a single bottom border on a cell and then use the underline font style. As you can see, this does creates two lines, but the top line is only as wide as the characters in the cell. Therefore, it won’t really look like a true double underline.

underline font
Single underline with an underline font format
Watch the video

This site has a companion YouTube channel that has pretty much, well almost exactly, the same content. If you like this, you'll like that.

Underscores and strikethrough

The next option is to type use insert a line of underscores (to the right of the zero hold down shift) in a cell and then apply the strikethrough font style. This will create a double line. The disadvantage of this technique though is that it will be a fixed width. Therefore, if the width of the cell changes, this “underline” will not be the right size anymore.

dash strikethrough
Underscores with the strikethrough
dash strikethrough align right
Underscores after column width changes

Two single bottom borders

The next option is to use the single bottom border on two rows and then shrink the row height to make it look like a double underline. In my opinion, this is most likely going to be your best bet.

two single borders
Two bottom borders
two single borders
Two bottom borders with a shortened row

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>