+ Reply to Thread
Results 1 to 3 of 3

Pivot table questions

  1. #1
    Registered User
    Join Date
    08-15-2008
    Location
    denver
    Posts
    68

    Pivot table questions

    While I love pivot tables, there are a couple of things that have always bugged me, but maybe there are options that I can select to change those. Using Excel 2013:

    1. When I create a pivot table, the default headings are "Row Labels" and "Column Labels". That seems like overly obvious, and useless information. Is there a way to have this display the actual column heading from the source data table?

    2. When I float my curser around a pivot table, there is this annoying pop-up that attempts to describe where I am on the table. Is there a way to turn this off?

    Thanks

  2. #2
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Pivot table questions

    1) You can override the default headings by typing any text into the cell. I'm unaware of a default way to do this.

    2) Right click on Pivot table, Select Pivot Table options, go to Display Tab, Uncheck show contextual tooltips.

  3. #3
    Registered User
    Join Date
    08-15-2008
    Location
    denver
    Posts
    68

    Re: Pivot table questions

    Thanks! I appreciate it

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot table questions...
    By nattielou in forum Excel General
    Replies: 0
    Last Post: 04-08-2010, 09:39 AM
  2. Pivot Table Questions
    By William Elerding in forum Excel General
    Replies: 3
    Last Post: 10-15-2005, 04:05 PM
  3. Pivot Table questions
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 10-12-2005, 06:05 PM
  4. Pivot Table questions
    By Dave in forum Excel General
    Replies: 2
    Last Post: 08-23-2005, 05:05 PM
  5. [SOLVED] Pivot Table Questions
    By Frederick Chow in forum Excel General
    Replies: 1
    Last Post: 06-26-2005, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1