Cell indent outline structure is one of two use cases where the position of values in a cell gives us the outline structure.
You can indent the values in a cell by using the indent and outdent controls on the “Alignment” section of the “Home” tab on the Excel Ribbon bar, as indicated below:
This is a very common way of showing the reader the hierarchical structure of the content they are reading.
Here is an example of cell indent formatted data, before and after TreeWiz Outline Grouping:
Here is a simple example of data using cell value indenting, before and after grouping by TreeWiz:
Note: it is quite common for the cell indenting to not be set up exactly as the user wants the data to be structured. This is because the level of indent needed for the eye to see structure doesn’t have to be arithmetically perfect in the same way that TreeWiz treats indenting for the purposes of outline structuring.
There are a few ways around this:
- Trial and Error: perform the TreeWiz “Group by Cell Indent” function and check the results. Manually correct the cell indent on incorrect rows/columns, remove the grouping and then rerun the “Group by Cell Indent” function. Continue until you’re satisfied with the result
- Expose the Cell Indent Level in a formula: TreeWiz provides a function that returns the Outline Level based on Cell Indent. Once you’ve set this up you can see the cell values that provide incorrect outline levels. You can correct the indent manually and then re-run the Grouping function.
- Execute the “Check Outline Structure” in the “Tools” section of the TreeWiz tab in the Ribbon Menu.