Lesson 5

Preview

Format Cells – Font Tab; Practice Exercise 5

Practice Exercise 5:  Use the Format Cells Font tab to perform superscript and subscript formatting, as well as reset all cell formatting using the Normal font checkbox.

On the Format Cells dialog box, select the tab “Font” (FIGURE 1).

Figure 1

Accounting Underlines
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

STEP 2: Make cell D2 the active cell. Right-button mouse click cell D2 and select Format Cells. In the Format Cells dialog box, select the Font tab. In the “Underline” section, select  “Single” from the drop-down menu (FIGURE 3). Select OK button.

Figure 3

​Note the differences between “Single Accounting” and “Single”. Single Accounting adds a single underline that is noticeably lower than the Single underline. Additionally, the width of the underline extends the entire cell width if the cell contains text or dates (FIGURE 4).

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.

Figure 5

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 6

​Notice the difference between “Double Accounting” and “Double”.
Double accounting adds a double-underline that is noticeably lower than the Double underline. In addition, the width of the underline extends the entire cell width if the cell contains text or dates (FIGURE 7).

Figure 7

Practice Exercise Preparatory Activities: If you have not opened the Excel data file “FORMAT CELLS EXERCISES” do so now. Select the tab “Formatting & Reset”

Formatting cell(s) and Reset Cells to the Excel Default

(FIGURE 8) ​These are the default settings for Excel’s font; Calibri (body), Regular, Size 11. All of the fonts are True Type fonts, meaning they will display and print exactly the same.

Figure 8

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:

  • Font A R Christy
  • red font
  • 16 point
  • Bold
  • Italics

After applying the above formatting changes to the text, the text should look similar to FIGURE 9.

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.
​Select OK.

Figure 10

The result is shown in FIGURE 11.

Figure 11

Apply Superscript, Subscript, and Strikethrough Formatting to a cell(s).

STEP 7: Make cell B1 the active cell. In cell B1, highlight only the letters “super” in the name “superscript test”.  (FIGURE 12). 

Figure 12

STEP 8: On the Format Cells Font tab, in the “Effects” section, check the box “Superscript” (FIGURE 13). Select the OK button.

Figure 13

​STEP 9: The superscript effect is shown in FIGURE 14.

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).

Figure 15

STEP 11: On the Format Cells Font tab, in the “Effects” section, check the box “Subscript” (FIGURE 16). Select the OK button.

Figure 16

​STEP 12: The subscript effect is shown in FIGURE 17.

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).

Figure 18

STEP 14: On the Format Cells Font tab, in the “Effects” section, check the box “Strikethrough” (FIGURE 19). 

Figure 19

STEP 15: The strikethrough effect is shown in FIGURE 20.

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.


END OF LESSON

Back to: Intermediate Excel 2016 > Module 1 – Intermediate Excel 2016

Leave a Reply