Let's continue from the previous example. Please note that the cell borders that show up in Excel by default are no. Worth noting, however, is that numbers will not be reflected in the same way as text unless they are changed to accounting format (as seen in the answer provided by ashleedawg). This is the more standard answer you'll find across the web. Single underline text where almost the entire cell width is underlinedĭouble underline text where only the word is underlinedĭouble underline text where almost the entire cell width is underlined To add italics, boldfaced, or underlining to data in cells, select the desired. Underline, click 'Font,' and set it to use 'single accounting' style. The Underline button remembers your last selection. It also provides a menu for selecting single and double-underlining. The Underline button toggles underlining on and off. Single underline text where only the word is underlined For most basic underlining, you can just use the Underline button on the ribbon. We can also set underline style to: Value Both properties of Font can either be true or false. Bold Italic Underline Strikethrough In the Cell tab, choose an option. We can set whether the font is bold or italic. Format one or more cells In the Text tab, choose an option to format your text. To remove the double underline, simply select your. For instance, we can set the font name, color, and size. Selecting your text in Word and hitting Ctrl+Shift+D immediately adds a double underline to your text. You will find it in the Home tab, under the ‘Font’ group. Click the arrow next to the Borders button. In your case, (if I understand you right) you would highlight all cells from A1 to K10 (assuming a maximum of ten rows), and then make the conditional formatting formula as follows: AND (NOT (ISBLANK (A1)),ISBLANK (A2)) Then just apply the border by setting it up in the 'Format.' options as shown in the examples.
![how to underline in excel without border feature how to underline in excel without border feature](https://i.ytimg.com/vi/v9uRiLYxZpc/maxresdefault.jpg)
To select a group of cells, drag your mouse over the group of cells you want to select. To select individual cells, press down the control key, and select each cell. The Font property of a CellStyle is where we set font-related formatting. Select the cells around which you want to add borders.