Report Layout-Uses the Compact, Outline, or Tabular forms.Grand Totals-Turns the grand totals on or off for rows and columns.Subtotals-Moves subtotals to the top or bottom of each group or turns them off. Layout changes are controlled in the Layout group of the Design tab, as shown in Figure 3.8. If you consider three report layouts, and the ability to show subtotals at the top or bottom, plus choices for blank rows and Repeat All Item Labels, you have 16 different layout possibilities available. The Excel team continues to offer the newer Compact layout as the default report layout, even though I continually hound them about the fact that people who work in the real world would rather use the Tabular report layout, or at least would like to have a choice about which one to use as a default. Learn More Buy Making Report Layout ChangesĮxcel 2016 offers three report layout styles.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |