Results 1 to 2 of 2

Pivot Table 'blank' row and Column.

Threaded View

  1. 10-08-2013, 07:00 PM #1
    johnwilkowilson
    johnwilkowilson is offline
    Registered User
    Join Date
    10-08-2013
    Location
    Christchurch
    MS-Off Ver
    Excel 2010
    Posts
    1

    Pivot Table 'blank' row and Column.

    Hi,

    From the picture (attahcment) you can see the 'blank' row (10) and Column (Q). There is no row termed 'blank' in the data entry sheet (sheet 1). How can i get rid of both the 'blank' column and row for good so when it comes to entering further data that it doesnt appear again?

    Thanks

    j
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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 Formatting - Repeating column lables show up blank
    By pph213 in forum Excel General
    Replies: 0
    Last Post: 06-11-2012, 10:28 AM
  2. "BLANK" in column and row on a pivot table
    By Rmnticjas in forum Excel General
    Replies: 3
    Last Post: 01-23-2010, 12:05 PM
  3. pivot table counting blank cells in data table
    By nicko54 in forum Excel General
    Replies: 4
    Last Post: 09-23-2008, 11:26 AM
  4. pivot table counting blank cells in data table Continued
    By nicko54 in forum Excel General
    Replies: 2
    Last Post: 09-23-2008, 11:01 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1