When the signature column needs to be underlined in Excel, do you find that the underlined line is not displayed? Neither of these two methods has achieved the expected results. After some research, I finally found the technology of dynamically adding underline.

Underline directly?

When you need to underline, will you add it? First, type a few spaces, then select and click Add Underline? Do not display results.

Add border underline?

Adding a bottom border directly to the cell will have the effect of underlining, but this is not what you want at all.

Correct underline

Select the cell, use the shortcut key Ctrl+ 1 to open the setting cell, click the custom type, delete the content and change it to; ; ; @ * _, confirm to complete the setting. Cells set in this way can also follow the border!

The above are the skills shared today ~ accumulating more skills at ordinary times is of great help to improve the application level of Excel!

That's what Bian Xiao shared for everyone! Excel underline changes with the change of cell column width. I guess you don't know the relevant content yet. For more information, you can pay attention to Global Ivy and share more dry goods.