Go to the Font tab and select the appropriate option from the Underline drop down list. Alternatively (and this also works in Excel 20), you can right-click on the cell in question and choose Format Cells. The cell will have a double underline, as shown in Fig. Values in cells C12 through C14 will be the same as that in Figure 3 as long as the value in cell C11 does not equal to 0. In the Underline dropdown, choose double or double accounting. Similarly, column G presents what returned by FORMAT function in column H. Displays On is the number is not 0.ĭisplays date based on your system settingsĭisplays date based on your system’s long date settingĭisplays date based on your system’s medium date settingĭisplays date based on your system’s short date settingĭisplays time based on your system’s long time settingĭisplays time based on your system’s medium time settingĭisplays time based on your system’s short time setting Displays True if the number is not 0.ĭisplays Off if the number is 0. Displays Yes if the number is not 0.ĭisplays False if the number is 0. Displays two digits to the right of the decimal place.ĭisplays No if the number is 0. We'll look at borders more closely in an upcoming lesson.Displays a number without thousand separators.ĭisplays a thousand separators as well as two decimal places.ĭisplays at least one digit to the left of the decimal place and two digits to the right of the decimal place.ĭisplays a thousand separators, at least one digit to the left of the decimal place, and two digits to the right of the decimal place.ĭisplays a percent value – that is, a number multiplied by 100 with a percent sign.
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. This doesn't happen with other number formats or when the selection contains content in different formats. Format Painter, so click on the jail cell that you want to apply the same style to. Then, find the Format Painter tool on the Home tab on Excel’s ribbon. 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. Offset off by clicking in the cell that has the format that you want to copy. 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 also provides a menu for selecting single and double-underlining.
The Underline button toggles underlining on and off. 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)
