If we press the OK button only Excel we close the dialog box and will not outline our data.
We could also make Excel to apply different styles to different levels of the outline by activating the check box Automatic Styles and pressing the Create button. In the window Settings that appears, we deactivate the check boxes next to the commands Summary Rows Below Detail or Summary Columns To Right. In order to do that we just select the right arrow that is in the corner of the Outline area of the Data tab, in order for the appropriate dialog box to appear as we can see in the image below. If though, the summary rows are above and the summary columns are to the left, Excel can still build the outline Straight away our data of the spreadsheet have been outlined as we can see in the image below.Įxcel assumes that the summary rows in the data table are below their detailed data, and that the summary columns are to the right of the detailed data. Then we select the Data Tab and from the area of the ribbon named Outline, we select the command Group as we can see in the following image where from the drop down menu we select the command Auto Outline. To create an Outline for the data of a table, we select a cell from where our data is and that we want to be grouped. The Outline feature helps us to show quickly a summary row or summary column, or to display all the data’s details for every group. If we have a data list which we want to group and condense, we can create an outline up to eight different levels. Once we have Outlined a table or a list, we can condense the table in order to show certain levels of information, and also easily expand the table or list to display various levels of data.
The Outline features let us control the level of details that will be shown in a data table or in a list of a worksheet.
0 kommentar(er)
