Now, only the visible subtotal rows are selected. Select the Visible Cells Only option button.Click Special to display the Go To Special dialog box.Press F5 to display the Go To dialog box.Using the Outline area at the left of the screen, collapse the detail in your worksheet so that only the subtotals are showing.Select the entire data table, including the subtotals.If you use subtotals sparingly, and only want to apply a different format for one or two worksheets, you can follow these general steps: You, however, may want to have some different type of formatting for the subtotals, such as shading them in yellow or a different color. When you add subtotals to a worksheet, Excel automatically formats the subtotals using a bold font.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |