This quickly reformats one underlined word, phrase or section in your document. Press “Ctrl-U” on your computer’s keyboard to remove the underline from your selected text. This tells the browser not to decorate the text (i.e. Specifically, you need to use: text-decoration: none. To remove the underline from a hyperlink, you need to use the CSS text-decoration property. How do you override the underlining of hyperlinks? How do I change a hyperlink to normal text in Excel?.How do I change a hyperlink to regular text in Word?.How do you remove hyperlinks from a Word document?.How do I get blue links to show instead of hyperlinks?.
![get rid of an underline in excel get rid of an underline in excel](https://tipsmake.com/data/images/how-to-use-underline-styles-in-excel-picture-2-MvgW2AK1K.jpg)
![get rid of an underline in excel get rid of an underline in excel](https://v8r5x7v2.rocketcdn.me/wp-content/uploads/2022/01/how-to-remove-underline-word-for-office-365-2.jpg)
I'm working on an Excel 97-2003 (.xls) workbook using compatibility mode from Excel 2016 but I see 2007 has the same commands I used below.Īnother thing that worked on some was to type a blank into the empty cells between the other data. I tried 6 of the 7 answers that were here (excepted the text boxing) and with a bit of fiddling the ideas all worked but, on some rows only. A terrible and labor intensive solution, but it does work.
#GET RID OF AN UNDERLINE IN EXCEL HOW TO#
I then make sure the column is a little wider than my chosen text width, and I won't get any extra blank lines. This video shows you how to remove Underline in MS Excel 2016.Excel Tips & Tricks. In this case, the only solution that I have found is to manually wrap the text to my chosen width by inserting extra carriage returns in the middle of the text at the position that I'd like the text to wrap using alt+enter. Changing the width will clean up some cells, and add unnecessary blanks to others. Of course, if your worksheet has hundreds of rows, then each cell in that column has a certain chance of hitting the magic spot, and adding the extra line. Once the column is wider, auto size the row by double-clicking the divider between the row headers on the left side of the worksheet. You can widen the column by clicking and dragging the divider between the two column headers at the top of the worksheet. Try different widths until auto-sizing the height gets rid of the blank line. Apparently word wrap messes up with particular cell values and particular widths. I found that if you change the width of the column that contains the cell with the extra blank line, then auto sizing the height of the row will usually get rid of the extra blank line. I am using Office/Excel 2007 for Windows. But, I need to enter in comments on this sheet and use the Text Wrap feature. Is there some other setting I can use to get rid of this extra blank line? I realize that Excel isn't really made for word processing. Nothing there gets rid of this extra blank line. I have searched the Format Cells window.I am using the default font when I am entering the text. I am not using Bold, Italic or any other font setting.
![get rid of an underline in excel get rid of an underline in excel](https://www.msoutlook.info/pictures/styles-dialog-modify-hyperlink-2010.png)
I tried copying/pasting the text into Notepad and then back into Excel to try to get rid of any formatting.Adjusting the width of the cell doesn't help.
![get rid of an underline in excel get rid of an underline in excel](https://www.excelarticles.com/image/LE10001177.jpg)