10 September, 2012

Unable to See "+" and "-" Group/Ungroup in Certain Excel Worksheets

When I select and Group multiple rows, I cannot see the "-" (collapse) or the "+" (expand) signs on the left of the spreadsheet.  This happens for both Rows and Column groups.  This happens for only certain Tabs (Worksheets) within the Workbook.
OR I have grouped some columns, but now I can't see the button on the top of the grouped ones. I tried to group/ungroup again and, as there were some hidden rows, I tried to unhide them all and it is still not working.
OR how do you group and ungroup rows or columns in new Excel?
Resolution:
Show or hide outlined data

1. If you don't see the outline symbols 1,2,3, +, and -, click the Microsoft Office Button, click Excel Options, click the Advanced category, and then under the Display for this worksheet section, select the worksheet, and select the Show outline symbols if an outline is applied check box.
2. Do one or more of the following:
Show or hide the detail data for a group
  • To display the detail data within a group, click the + for the group.
  • To hide the detail data for a group, click the - for the group.
Expand or collapse the entire outline to a particular level
  • In the 1,2,3 outline symbols, click the number of the level that you want. Detail data at lower levels is then hidden.
For example, if an outline has four levels, you can hide the fourth level while displaying the rest of the levels by clicking 3.
Show or hide all of the outlined detail data
  • To show all detail data, click the lowest level in the 1,2,3 outline symbols. For example, if there are three levels, click 3.
  • To hide all detail data, click1.

No comments:

Post a Comment

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.