+ Reply to Thread
Results 1 to 2 of 2

How to remove lines and blue colour shades from pivot tables

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    Grand Cayman, Cayman Islands
    MS-Off Ver
    2010
    Posts
    1

    Post How to remove lines and blue colour shades from pivot tables

    I need guidance on the steps to take to remove lines from the report resulting from a pivot table. Can you help me please?

  2. #2
    Registered User
    Join Date
    10-05-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2019
    Posts
    74

    Re: How to remove lines and blue colour shades from pivot tables

    Select "Design", under "PivotTable Styles" select the drop down cursor then select "Clear"(Refer image).

    Is it the result you want? If yes, please mark the thread as Solved. Thanks

    Screenshot_1.jpg

+ 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. Replies: 3
    Last Post: 08-21-2012, 09:26 AM
  2. Remove ALL lines from Pivot Tables
    By DOMTRUMP in forum Excel General
    Replies: 3
    Last Post: 05-25-2010, 11:07 AM
  3. keep background colour in pivot tables
    By blackstar in forum Excel General
    Replies: 0
    Last Post: 04-24-2007, 04:09 PM
  4. How do I remove lines from a Pivot Table in Excel?
    By Genevieve in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-11-2006, 09:40 PM
  5. [SOLVED] Colour Banding in pivot tables
    By Frederick Chow in forum Excel General
    Replies: 1
    Last Post: 06-25-2005, 03:05 PM
  6. Ignoring Lines with Errors in Pivot Tables
    By Darren in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-22-2005, 06:06 PM
  7. [SOLVED] In Excel Auditing linking lines(blue colour) are not shown proper.
    By Parvath in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-25-2005, 07:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1