In cells, how to delete a line that has an underline anywhere in that line

Mansour_Dalir 2,036 Reputation points
2024-12-29T12:22:47.9766667+00:00

Is it possible to delete the underlined lines in another cell in Excel?

User's image

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Barry Schwarz 3,746 Reputation points
    2024-12-30T02:27:13.1+00:00

    When you say anywhere in that line do mean anywhere in that row?

    To delete all the underlines in a row of cells, first select the row by clicking on the row number, then press Ctrl-1, select the font tab, click the arrow to the right of the underline drop-down box, select None, and click OK.

    The same procedure should work for any group of selected cells.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.