![]() ![]() Going across the columns, the data is separated into months which are then totaled after each quarter. In the example below, going down the rows, the data is organized into cities ( London, Paris, and New York), and in each of these cities there are categories for values which are totaled at the top of each city. First, organize your data logically with subtotals and then click somewhere within the data.The data cannot have any blank rows or columns, or spaces. You would need to have the information correctly organized in a logical manner where there are subtotals for each level of information you wish to group on. If the data in your worksheet is organized in a way that is compatible with Excel’s grouping functionality, you can use the Auto Outline feature. This tutorial will demonstrate how to automatically create an outline to group rows and columns in Excel.Įxcel has a grouping functionality that enables you to combine rows and/or columns into logical groups. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |