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. The form makes this process easier and Excel has a button interface to assist with the data. For example, if we apply Underlining to cells in the Currency format, Excel does not use the accounting version. You can turn your Excel spreadsheet data into a form when you need to perform repetitive data entry.
This doesn't happen with other number formats or when the selection contains content in different formats. 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. You can use any one of these or multiple ones in any combination. The underline button also contains a menu that lets you apply a double underline. You can mix and match bold, italic, and underlining in any combination. 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. The first click turns on the style, and the second click turns it off again. For most basic underlining, you can just use the Underline button on the ribbon. Click the Bold (B), Italic (I), or Underline (U) command on the Home tab. The italic and underline styles work the same way. To use these commands: Select the cell(s) you want to modify. The accounting variants of underline options increase the row height a bit and provide more space between the underline and the text. Adding an underline is ideal for a summary cell, like a subtotal or conclusion. 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.
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. Excel provides both single and double underlining.
0 kommentar(er)
