When you are applying formatting to some of the data in a spreadsheet, you might only stick to the more common options like bold, italic, and underline.
But Microsoft Excel has a much larger selection of formatting choices that you can use to get the right point across.
Our tutorial below will show you how to double underline in Excel with the help of an option you can find on the Format Cells menu.
How to Use Microsoft Excel Double Underline Formatting
- Open your Excel file.
- Select the cells to modify.
- Choose the Home tab.
- Click the Font Settings button.
- Select the Underline menu and choose Double.
- Click OK.
Our guide continues below with additional information on how to double underline in Excel, including pictures of these steps.
Working with data is often more than simply using the right formula to perform your calculations.
There are many different types of formatting that you can apply to the numbers or words in your Excel spreadsheet, and even very experienced Excel users are unlikely to encounter, much less use, all of these options.
One of the formatting options that I see very little of is underlining other than the standard single-underlining option in Excel. But there are actually several different underline options in Excel 2013, including a Double Underline option.
Our guide below will show you how to select a cell or group of cells, then apply formatting that will apply a double underline to the data in those cells. If you are working with a colleague or client that requires certain fields to have double underlines, then you can follow this guide.
Related: Our remove strikethrough in Excel article can show you how to add or remove lines through text in your spreadsheet.
How to Double Underline a Value (Numbers or Letters) in Microsoft Excel 2013 (guide with Pictures)
The steps in this article were performed in Excel 2013, but will work in Excel 2010 or 2016 as well.
Step 1: Open the spreadsheet containing the value(s) that you wish to double underline.
Step 2: Select the cell(s) to which you want to apply the double underline formatting.
Note that you can select an entire row by clicking the row number at the left of the sheet, or you can select an entire column by clicking the column letter.
Step 3: Click the Home tab at the top of the window.
Step 4: Click the small Font Settings button at the bottom-right corner of the Font section of the ribbon.
Step 4: Click the Underline dropdown menu, select the Double option, then click the OK button at the bottom of the window.
Note that there is also a Double Accounting underline option, if you would prefer to use that styling instead.
You can use this same method if you have some cells with the double underline formatting that you want to remove. Simply select those cells, then come back to the Format Cells dialog box and switch the Underline dropdown menu setting back to None.
Now that you know how to double underline in Excel, you will be able to apply or remove this formatting in the spreadsheets that you edit.
Is there too much formatting applied to your cells, and it’s becoming difficult to edit or remove it? Learn how to clear all of your cell formatting in Excel and start over with data that doesn’t contain any formatting.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.