![how to make double underline in excel how to make double underline in excel](https://www.excelarticles.com/image/LE10001176.jpg)
You can then press F2 to edit the contents. Microsoft Excel for Mac has several options for formatting cells to help organize information in business spreadsheets, including two types of double. Click in a nearby cell that doesn’t have a hyperlink and use the arrow keys on your keyboard to select the hyperlinked cell.Make the column a bit wider so there is white space within the cell so you can click or double click there without activating the hyperlink.This will select the cell instead of activate the hyperlink. Click and hold down the mouse button bit longer on the hyperlink.This example sets the font in the active cell on Sheet1 to single underline. Excel inserts your chosen double underline. Click the 'Underline' pull-down menu and select either 'Double' or 'Double Accounting.' Click the 'OK' button. Click the 'Font' tab on the Format Cells dialog box. Can be one of the XlUnderlineStyle constants. Similarly, how do you create a double rule in Excel Excel displays the Format Cells dialog box. expression A variable that represents a Font object. If you don’t want to turn of the feature (for instance when the recipient of the Excel sheet needs to be able to click on the links), you can also use one of the following alternative clicking or selection methods Returns or sets the type of underline applied to the font. Note: If this option is left enabled and AutoCorrect changes the address into a hyperlink, you can press CTRL+Z to directly undo the change.ĪutoFormat can recognize email address and convert them to Mailto links. File-> Options-> Proofing-> AutoCorrect Options.-> AutoFormat As You Type-> uncheck: Internet and network paths with hyperlinks.If you want one-click access to either the single or double underline, there are three Quick Access Toolbar icons. To apply a single underline, you then have to use the dropdown next to the Double Underline icon.
![how to make double underline in excel how to make double underline in excel](https://spreadsheetdaddy.com/wp-content/uploads/2021/09/how-to-underline-a-cell.png)
To disable the automatic hyperlink feature in Excel choose Gotcha: When you choose Double Underline from the Home tab's Underline dropdown, the Underline icon changes to a Double Underline icon. If you actually need to work with the data rather than to follow links, you can turns this function off or use an alternative clicking/selection method for cells that contain hyperlinks. The automatic conversion of typed email address into clickable mailto links in Excel is controlled by the same AutoCorrect option that turns typed internet addresses (URLs) into clickable hyperlinks. Is there any way to disable this behavior in Excel? When updating a field, it turns the email address in a clickable “mailto” link and when I’m not careful when clicking, it opens up a new email in Outlook.Īs I have no intention to email anyone directly from these lists, but do work a lot with these sheets, this is getting annoying quite fast. I’m working with Excel sheets that contain a lot of email addresses as well.