We'll look at borders more closely in an upcoming lesson. Unlike text underlining, cell borders run edge to edge across the entire cell. In fact, when the selection contains any format but Accounting, normal underlining will be applied.įinally, depending on your needs, keep in mind that applying a border on the bottom of cells is another way of underlining content in Excel. For example, if we apply Underlining to cells in the Currency format, Excel does not use the accounting version. setting the cell format to accounting does the trick. Id like to do it myself but I can only get it to underline the text/number width and not the entire cell width like the below pic. This doesn't happen with other number formats or when the selection contains content in different formats. How do I underline the entire cell width like so This was sent to me in another file and Ive been copying the format. There's no indication that this has been done, but you can see the accounting version has been applied in the Format Cells dialog box. Note that Excel will automatically apply the accounting version of underlining in cases where the selection contains only cells using the Accounting format. We can see this if we apply the different formats side by side. The accounting variants of underline options increase the row height a bit and provide more space between the underline and the text. You can't see these options on the ribbon, but in the Format Cells dialog box, you'll find them listed in the Underline menu as "Single Accounting" and "Double Accounting." For example, if you apply a Double Underline, the button will keep that selection until you select Single Underline again.Įxcel actually provides two more underline options for use with the Accounting number format.
The Underline button remembers your last selection. It is most often used in technical Excel actually provides two more underline options for use with the Accounting number format.
How do you double underline in Excel Strategy: You select the grand total cell and, instead of clicking the Underline icon, you click the dropdown arrow next to the Underline icon. 6 hours ago &0183 &32 Most of the functions can be used directly from a worksheet cell, or called from a VBA module. It also provides a menu for selecting single and double-underlining. You can also underline text and spaces in several other ways. The Underline button toggles underlining on and off. Click the Format option and then click on Underline (or use the keyboard shortcut Control + U) The above steps would underline the selected text in the cell. Select the text that you want to underline in the cell.
Double-click on the cell (or press F2) to get into the edit mode. It also provides a special variant of each for numbers using the Accounting format.įor most basic underlining, you can just use the Underline button on the ribbon. Select the cell that has the text that you want to underline. Excel provides both single and double underlining.
0 kommentar(er)
