Single Underlining is used to denote Subtotal and Double Underlining is used to denote Grand Total.
At the bottom of the worksheet, select the ACCOUNTING FORMATTING tab.
STEP 1: Make cell B2 the active cell. Right-button mouse click cell B2 and select Format Cells from the mouse shortcut menu. On the Format Cells dialog box, select the Font tab. In the “Underline” section, select “Single Accounting” (FIGURE 2) from the drop-down menu. Select OK button. |
FIGURE 2
FIGURE 3
Single Accounting Single
FIGURE 4
|
STEP 3: Make cell B5 the active cell. Right-button mouse click cell B5 and select Format Cells. In the Format Cells dialog box, select the Font tab. In the “Underline” section, select “Double Accounting” (FIGURE 5) from the drop-down menu. Select OK button.
STEP 4: Make cell D5 the active cell. Right-button mouse click cell D5 and select Format Cells. In the Format Cells dialog box, select the Font tab. In the “Underline” section, select “Double” from the drop-down menu (FIGURE 6). Select OK button.
|
FIGURE 5
FIGURE 6
Double Accounting Double
FIGURE 7
|
Create a new tab by selecting the + symbol at the bottom of the worksheet.
STEP 5: Make cell B2 the active cell. Right-button mouse click cell B2 and select Format Cells. On the Format Cells dialog box, select the Font tab. Apply the following format changes to cell B2:
After applying the above formatting changes to the text, the text should look similar to FIGURE 9. STEP 6: Check the Normal font checkbox (FIGURE 10) . Doing this will reset all font style or formatting changes back to the standard default, Calibri, Standard, 11 pt. |
FIGURE 9
FIGURE 10
FIGURE 11
|
Using the same data file Format Cells Exercises, select the tab “Superscript – Subscript”
STEP 7: Make cell B1 the active cell. In cell B1, highlight only the letters “super” in the name “superscript test”. (FIGURE 12). STEP 9: The superscript effect is shown in FIGURE 14. |
FIGURE 12
|
FIGURE 13
|
FIGURE 14
|
STEP 10: Make cell D1 the active cell. In cell D1, highlight only the letters “sub” in the name “subscript test” (FIGURE 15).
STEP 11: On the Format Cells Font tab, in the “Effects” section, check the box “Subscript” (FIGURE 16). Select the OK button. STEP 12: The subscript effect is shown in FIGURE 17. |
FIGURE 15
|
FIGURE 16
|
FIGURE 17
|
STEP 13: Make cell F1 the active cell. In cell F1, highlight only the letters “strike” in the name “strikethrough test”. (FIGURE 18).
STEP 14: On the Format Cells Font tab, in the “Effects” section, check the box “Strikethrough” (FIGURE 19). STEP 15: The strikethrough effect is shown in FIGURE 20. Note: If you desire to produce a superscript, subscript, or strikethrough of all data in the cell, you do not have to highlight anything. Excel will create the effect on all data in the cell automatically. |
FIGURE 18
|
FIGURE 19
|
FIGURE 20
|