The form in the Excel form is underlined, how to enter it

How do I underline a table? When we create some forms, we often enter underscores, mainly to let users fill in the content. Do you know how to type underline in Excel? Today, Mr. Wang came to share some methods with everyone!

1. Ctrl + U underline Select the blank cell, then click Start-Font-Underline, and then we can add underline by simply pressing the space. Of course, you can also use Ctrl + U to underline.

Shift + -(minus sign) We can also use the shortcut key "Shfit + -" to add underscores.

3, border line is more common method, we can directly add a "lower border line" to the cell as an underline.

4. Batch underline If you have many cells that need to be underlined, you can widen the cells first, then select these cells, right-click-"Set Cell Format"-"Number"-"Custom", enter "@*_" under the type, OK.

5. Multiple underscores in a cell If you need to underline multiple places in a cell, you can try using the "find and replace" method to solve it.

Select the cell, press Ctrl + H, enter "Space" in "Find Content", enter "_"(Shift + -) underscore in "Replace with", and click "Replace All".

This article comes from Weixin Official Accounts: Word Alliance (ID: Wordlm123), author: Wang Qi