![how to add underline in excel how to add underline in excel](http://www.croomphysics.com/graphics/excel/BoldUnderline.png)
If you would like to have multiple cells double-underlined you can either select multiple cells before choosing any borders and border styles.
#How to add underline in excel how to#
Double underlining multiple cells in Google Sheets How to add a double underline to multiple cells in Google Sheets That’s it, you have successfully double-underlined in Google Sheets. You have Double Underlined in Google Sheets You will see that the cell that was selected initially has a double underline.
![how to add underline in excel how to add underline in excel](https://www.excelarticles.com/image/LE10001178.jpg)
![how to add underline in excel how to add underline in excel](http://www.baycongroup.com/excel2007/images/02_Underline.gif)
Once the double line is selected you can click anywhere to get back to your Google sheet. Select double underline (two lines) Step 6 – Click on any cell to go back to the Google sheet Once selected you will see a checkmark on the left-hand side. Go ahead and select the last option from the “Border style” menu in Google Sheets. Click on Border style Step 5 – Select the two lines from the “Border style” menu Choose Bottom border Step 4 – Click on Border StyleĪfter selecting the “Bottom border” option click on “Border style” in the lower right corner of the menu.Ī new dropdown will open up. In the border menu that is popping up choose “Bottom border” on the lower right side of the menu. In the top menu just below the main Google Sheets navigation click on Borders Click on Borders Step 3 – Choose Bottom border Click and highlight a cell Step 2 – Click on Borders This means that you are now working in this cell and the changes you are doing will affect it. Once it is clicked it will become highlighted with a blue border. The first step is to click and highlight the cell you want to double underline in Google Sheets by clicking on it. There you can edit the value in the Address field to whatever page or file you wish to use instead.Īre you having trouble getting your spreadsheet to print well? Check out our Excel printing optimization guide for some tips that can solve a few of the problems you may be experiencing.Double Underline in Google Sheets Step-By-Step Step 1 – Select the cell
![how to add underline in excel how to add underline in excel](https://www.automateexcel.com/excel/wp-content/uploads/2022/01/underline-double.png)
If you want to edit the hyperlink so that it opens to a different Web page or file than what it is currently opening to, then you can right-click on the cell and choose the Edit Hyperlink option, which will open the Edit Hyperlink dialog box. You can change the color of the hyperlink text by selecting the cell, choosing the Home tab, then clicking the arrow next to the Font Color button in the Font group, then choosing the desired text color. This may be a preferable option if you would prefer to keep the text coloring from the hyperlink, and only want to remove the underline. This is also how you would apply underline formatting to text. You will need to select the cell with the underline, click the Home tab, then click the Underline button in the Font group of the ribbon. You can also select the entire spreadsheet by pressing the Ctrl + A keyboard shortcut, or by clicking the gray button above the row 1 heading, and to the left of the column A heading.Īnother way that you can remove the underline from a hyperlink also applies to other text that has an underline. You can select multiple cells at a time in Microsoft Excel by clicking and dragging, or by holding down the Ctrl key on your keyboard and clicking each cell that you want to select. In this article, we take advantage of that to remove the link text color and underline, but you can also use it to remove formatting from other cells in your spreadsheet as well. Note that when you select a cell and choose the “Clear Formats” option, it will get rid of most of the formatting that has been applied to that cell. Step 2: Click the cell containing the hyperlink whose underline and color you wish to remove. Step 1: Open the spreadsheet in Excel 2013. Note that the steps below focus on performing this action on one link, but you can do it to multiple links by selecting a range of cells instead of just a single one. If you would prefer to remove the hyperlink and its formatting, then read this article on removing hyperlinks in Excel 2013. You will still be able to click the link, however, if you so choose. The steps in this article will show you how to change the formatting of a hyperlink (or hyperlinks) in an Excel 2013 spreadsheet. How to Remove the Underline and Color from a Hyperlink in Excel 2013 (Guide with Pictures) Our guide continues below with additional information on removing underlines from links in Excel, including pictures of these steps. 4 Additional Reading How to Remove Underline from Link in Excel 2013