Jun 30 2021 05:19 AM
See Attached screen shot. I have clicked on something to display a gray top bar and left side on my worksheet. Does anyone know what this is and how to turn off??
Jun 30 2021 05:25 AM
It is an outline.
Activate the Data tab of the ribbon.
In the Outline group, select Ungroup > Clear Outline.
Jun 30 2021 05:30 AM
Solution
Outline (group) data in a worksheet
To display rows for a level, click the appropriate
outline symbols.
2. Level 1 contains the total sales for all detail rows.
3. Level 2 contains total sales for each month in each region.
4. Level 3 contains detail rows — in this case, rows 17 through 20.
5. To expand or collapse data in your outline, click the
and outline symbols, or press ALT+SHIFT+= to expand and ALT+SHIFT+- to collapse.
Hope I was able to help you with this info.
*For example, see your inserted file in this message.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jun 30 2021 05:30 AM
Solution
Outline (group) data in a worksheet
To display rows for a level, click the appropriate
outline symbols.
2. Level 1 contains the total sales for all detail rows.
3. Level 2 contains total sales for each month in each region.
4. Level 3 contains detail rows — in this case, rows 17 through 20.
5. To expand or collapse data in your outline, click the
and outline symbols, or press ALT+SHIFT+= to expand and ALT+SHIFT+- to collapse.
Hope I was able to help you with this info.
*For example, see your inserted file in this message.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.