Forum Discussion
Outline not showing + and -
When I use the Outline function in the data tab, I select a couple of columns. But the + and - sign that should come up above the column does not. I only get a small mark at one of the columns and I have circled it in the image I have attached. How do I get the default view back? I have already checked File -> Options -> Advanced -> Show options for this workbook / worksheet: Show outline symbols if an outline has been applied -> checkmark!
1 Reply
First select the appropriate grouping columns and clean up the old outline grouping, check for hidden rows, make sure the data is formatted correctly and there are no merged cells, and finally update Excel to the latest version.
