CODEWITHSUNDEEP
excelms-office
Ela Buwa
Ela Buwa

Reputation: 1704

Excel underline only to cell width (cell's text goes in to other cells)

I have a normal excel which has certain cell's texts which are greater than it's width and overflows to the next cell (the overflown cells are empty). IE : Cell A1 has text that goes in to cell A2.

If I try to underline all the text in A1, the underline goes as far as the width of the cell. I am not trying to underline using borders either. I am trying with the standard U (underline) symbol.enter image description here

If you see the red circled ones above the, I belive you guys can understand the issue. I need the underline to work on all cells that overflow to the other texts.

I have considered using borders as an alternative, but in some cases, the text does not cover the entire overflown text which makes the border fail at working as an underline.

Any help is greatly appreciated.

Upvotes: 1

Views: 4474

Answers (2)

PKumar
PKumar

Reputation: 11128

Its the problem with selection of "single accounting" option. Instead of "Single" you might have selected "single accounting" in underline option mistakenly.

See the below screenshots for comparision.

Hope this helps

enter image description here

enter image description here

Upvotes: 5

Gary's Student
Gary's Student

Reputation: 96753

Make sure that you have not accidentally set the cell border rather than the text property.

Upvotes: 0

Related Questions