excel for mac pivottable question

Discussion in 'Mac Apps and Mac App Store' started by sir42, Oct 3, 2007.

Most Liked Posts
  1. sir42, Oct 3, 2007

    sir42 macrumors 6502

    Joined:
    Sep 16, 2003
    Location:
    NY, NY
    #1
    When I work with pivottables on my PC at work using Excel 2003, I can hide or unhide category rows by simply selecting the down arrow at the top of the category row, and selecting or deslecting the rows that I want to hide or unhide from a checklist.

    However, when I'm working with the same excel pivottable on Excel 2004 for Mac, there is no down arrow at the top of the category row. Is there a way to hide and unhide category rows when using the pivottable on Excel 2004 for Mac?

    thanks!
     
    share
    + Quote Reply
  2. geofflilley, Nov 27, 2007

    geofflilley macrumors newbie

    Joined:
    Nov 27, 2007
    #2
    Field Settings

    If you're talking about the row field, what you can do is right-click on one of the row field values, and choose "Field Settings." You can then hold down Command and select multiple values to hide.

    If you're talking about the page field, no such luck. Your best bet for that is to create an additional column which differentiates the data in such a way that you can filter on a page field value. For example, if your page field contains state names (California, New Jersey, Nevada, Oregon, New York, New Hampshire, etc) and you want to see only the states in the Eastern Seaboard, then create an additional column in your data sheet called something like "region," with CA, NV, OR, WA, and AZ being the Pacific Northwest, and NJ, NY, MA, NH, and DE being the Eastern Seaboard. Then, make that "region" column the page field.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page