Wouldn't it be great if you could identify the subtotals in your worksheets so that you can find them easily? With the hacks in this section, you can.
When you are working with a spreadsheet that has subtotals you created by selecting Data → Subtotals, the subtotals can be very hard to identify, making the spreadsheet hard to read. This is true especially if you applied subtotals to a table of data with many columns.
Typically, the resulting subtotals appear on the right, while their associated headings are often in the first column. As the subtotal values are not in boldface, it can be hard to visually align them with their row headings. You can make these subtotals much easier to read by applying bold formatting to the subtotal values.
To test the problem, set up some data similar to that shown in Figure 2-19.
Figure 2-19. Worksheet data before adding subtotals
Now add the subtotals by selecting Data → Subtotals, accepting the defaults in the Subtotals dialog, and clicking OK.
In Figure 2-20, the subtotal headings have been boldfaced but their associated results have not. As this table has only two columns, it is not that hard to read and pick out the subtotal amounts.
Figure 2-20. Worksheet data after subtotals have been applied
The more columns ...