1. Open the excel table and select the cell range to be underlined.
#2. Right-click the mouse and select "Format Cells".
#3. As shown in the figure below, the "Format Cells" dialog box will pop up.
4. Switch the option to "Custom".
5. Enter @*_ in the type box, and then click the "OK" button.
#6. In this way, the selected areas will be underlined and added in batches.
Recommended tutorial:excel tutorial
The above is the detailed content of How to add underline in excel. For more information, please follow other related articles on the PHP Chinese website!