You can also create a custom Style that includes the attribute. Use Format> Cells - Font, open the Underline list & select either Single Accounting or Double Accounting.
Step 2: Select the cell(s) to which you want to apply the double underline formatting. The definition of that style is what calls for the blue color just as the other attributes it applies exactly as it is illustrated in the Gallery. Step 1: Open the spreadsheet containing the value(s) that you wish to double underline. The steps in this article were performed in Excel 2013, but will work in Excel 2010 or 2016 as well. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, its Control + U.
Double underline in excel on mac shortcut how to#
How to Double Underline a Value (Numbers or Letters) in Excel 2013 Finally, some Excel shortcuts are just plain different on a Mac. If you are working with a colleague or client that requires certain fields to have double underlines, then you can follow this guide. Step 3: After the option is added in a new tab, this will appear below in the ribbon. Step 2: From the options tab, choose to add New Tab and choose the Strikethrough option and click on OK. 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. Step 1: Right-click on the Font tab and choose the option of Customize the ribbon.
But there are actually several different underline options in Excel 2013, including a Double Underline option. One of the formatting options that I see very little of is underlining other than the standard single-underlining option in Excel. 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. Working with data is often more than simply using the right formula to perform your calculations.