how to remove blue lines in excel for mac

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

How to remove blue lines in excel for mac