+ Reply to Thread
Results 1 to 2 of 2

Move (blank) to top of pivot table

  1. #1
    Registered User
    Join Date
    11-14-2007
    Posts
    19

    Move (blank) to top of pivot table

    I created a pivot table and I want to show the blank cells as well as those with data. but the problem is that it is being listed as the last entry on the column. is there a way i can make it move to the top of the column without changing the way other data is recorded?

  2. #2
    Forum Contributor
    Join Date
    01-23-2006
    Posts
    194
    select the cell. hover over the top boundary of the cell and then drag it to where you want. In Table>options, switch off auto format It will still say "(blank)".

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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