- The power hour 100 items to disappear first how to#
- The power hour 100 items to disappear first plus#
NOTE: You can’t collapse the innermost field if you double-click on it. That double-click trick also works if the plus/minus signs are showing, so be careful when you double-clicking in a pivot table! It’s easy (maybe too easy!) – just double-click a cell in one of the outer pivot fields, to collapse or expand that item. If the Expand/Collapse buttons have been hidden, you can still expand or collapse the pivot items. In the Display section, add or remove the check mark for “Show expand/collapse buttons”.Right-click a pivot table cell, and click PivotTable Options.If you want to show or hide the Expand/Collapse buttons, follow these steps: The “Gray” last name was accidentally collapsed, before the Expand/Collapse buttons were hidden. So that’s why both Ida Gray and Ken Gray would have missing information.
It doesn’t just hide the Attending information in the Ida row – it hides the Attending information for anyone with “Gray” in the NameL field. What happens if you click the minus sign for the last name in the Ida Gray row? Hmmm…now we’re getting closer to solving the mystery.
The power hour 100 items to disappear first plus#
Later, click the plus sign to show them again. If you click the minus sign for Ida, the “Gray” and “Yes” disappear. The first name (NameF) and last name (NameL) fields have plus and minus signs too. Later, you can click the plus sign at the left of East to expand it again, and show all the hidden information. For example, if you click the minus sign at the left of East, it collapses - all the names for East are hidden. If you click one of the minus signs, everything in the fields below that is hidden. Those are the Expand/Collapse buttons, and here is a screen shot of the table with those buttons showing:
The power hour 100 items to disappear first how to#
I remembered that she had asked how to hide the pivot table’s plus and minus signs, earlier in our phone call. My friend hadn’t intentionally hidden them. The only remaining mystery was how those pivot items disappeared in the first place. How Did the Pivot Items Accidentally Collapse? I decided to dig a bit deeper though, into the secrets of how to expand and collapse pivot fields and pivot items. My friend was very happen, and got back to work on her project.
That wasn’t the problem – the Attending column had a “Yes” for both Ida Gray and Ken Gray.īut, just to be cautious, she copied a Yes from another row, and pasted it in the problem rows. Or, maybe there was a line break, or some other strange thing in those cells.Perhaps there was a space character in the Attending column, and that was showing in the pivot table.The next thing I asked my friend to do was to check the source data, to see what was entered in the table for those people. What else can we do to troubleshoot pivot items missing from a pivot table? The pivot items didn’t magically appear after the refresh. Unfortunately, that didn’t solve the problem. So, I asked my friend to right-click on the pivot table, and click Refresh, just in case that was the problem. Sometimes data isn’t visible because the pivot table hasn’t been refreshed recently. The correct information appears for other employees – you can see “No”, “Yes” and “(blank)” responses.