Underlining Totals

When your spreadsheet displays data that you sum to present totals, you may want to include the underline below the last number in the column you are totaling; you may also want to double-underline the total. In Quattro Pro, you can apply the appropriate accounting style to a selection, as I did in Figure 9.14.

Figure 9.14. Use Accounting Style to single-underline or double-underline values in a spreadsheet.

You can only apply one type of Accounting Style underlining to a selection. To apply single underlining to one selection and double underlining to a different selection, perform steps 15 twice.

To apply Accounting Style formatting, follow these steps:

1.	Select the cells to which you want to apply single underlining. In the sample spreadsheet shown in Figure 9.14, I selected B7.E7.
2.	Open the Format menu and click Selection Properties. Quattro Pro displays the Active Cells dialog box shown in Figure 9.15. Figure 9.15. Use the options in the Accounting Style section to apply single or double underlining to the selected cells.
3.	Click the Cell Font tab.
4.	In the Accounting Style section, click the option appropriate for the type of underlining you want to apply.
5.	Click OK.