Learning how to remove the underline and color from a link in Excel 2013 can be important if the link text formatting is distracting from the data in your spreadsheet. You may have discovered how to remove the link entirely, but would prefer to keep the link there without the text color or underline that visually identifies it as such.
Fortunately you can achieve this result by clearing the formatting from the cell instead of removing the link. Our tutorial below will walk you through the steps to do this.
How to Remove the Underline and Color from a Hyperlink in Excel 2013
The steps in this article will show you how to change the formatting of a hyperlink (or hyperlinks) in an Excel 2013 spreadsheet. You will still be able to click the link, however, if you so choose. If you would prefer to remove the hyperlink and its formatting, then read this article on removing hyperlinks 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.
Step 1: Open the spreadsheet in Excel 2013.
Step 2: Click the cell containing the hyperlink whose underline and color you wish to remove.
Step 3: Click the Home tab at the top of the window.
Step 4: Click the Clear button in the Editing section at the right end of the ribbon, then click the Clear Formats option.
The underline and the text color should be gone, but you should still be able to hover over the link and click it. If you would like to remove the link entirely, then you can do so by right-clicking the cell with the link, then click the Remove Hyperlink option.
Are 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.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.