+ Reply to Thread
Results 1 to 2 of 2

Small issue: make pivot table in same order as data, instead of alphabetically

  1. #1
    Registered User
    Join Date
    06-27-2018
    Location
    Paris, France
    MS-Off Ver
    Excel, 2016
    Posts
    14

    Small issue: make pivot table in same order as data, instead of alphabetically

    Hello all,

    As the thread title says, I need to show textual data in a pivot table in the exact same order as the rows are arranged in the source sheet. Despite arranging the rows in the order I want in the source sheet, the pivot table still shows the row items alphabetically which I don't want.

    How do I get the pivot table to show the data in the exact order as the source sheet instead of alphabetically?

    Thanks in advance!

  2. #2
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    677

    Re: Small issue: make pivot table in same order as data, instead of alphabetically

    Use custom list option
    File > Options > Advanced > Under General use 'Edit Custom Lists' > Import list from cells > Add > Ok
    Save and close the workbook, reopen the workbook and sort the data in pivot table.

+ 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. [SOLVED] Copying data to another sheet in order to make a pivot table
    By ninja_beth in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-09-2020, 06:42 PM
  2. Pivot table sorting alphabetically - with exception
    By Jabba69 in forum Excel General
    Replies: 4
    Last Post: 11-10-2017, 03:19 PM
  3. How to make a working stock order sheet for a small business?
    By Lukreative_Design in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-21-2016, 05:50 PM
  4. Data refresh on pivot table does not sort alphabetically
    By physicsgal in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-27-2013, 10:21 AM
  5. Replies: 3
    Last Post: 11-19-2012, 11:05 PM
  6. Multiple rows make a single order and Pivot table
    By saurya_s in forum Excel General
    Replies: 5
    Last Post: 10-30-2008, 01:51 PM
  7. Change Variable data on 1 pivot table, make same changes in other pivot tables
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2008, 10:55 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