+ Reply to Thread
Results 1 to 4 of 4

How to Keep the Order of a Filter

  1. #1
    Registered User
    Join Date
    02-03-2016
    Location
    Mount Gretna, PA
    MS-Off Ver
    2011
    Posts
    33

    How to Keep the Order of a Filter

    Hi, I just learned how to use filters for my columns. But what happened is that I used the filter for one of my columns and now I want to keep the order in which it sorted my data. Meaning prior to using the filters, I had it listed alphabetically and now with the filter I have it sorted by date. How do I remove the filters and keep my new date-ordered data? Have the date-ordered stuff be my default w/o the tabs and filters at the top of each column, w/o having to copy and paste each row. That seems tedious. Ty.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: How to Keep the Order of a Filter

    Hi "Learning Excel" and welcome to the forum,

    Here is a possible answer. You can create "custom" sort orders for your data. See:
    http://www.gcflearnfree.org/excel2013/18.2

    Now if that isn't even close to answering your problem, attach a sample workbook so we can better understand the question/problem.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    02-03-2016
    Location
    Mount Gretna, PA
    MS-Off Ver
    2011
    Posts
    33

    Re: How to Keep the Order of a Filter

    Can you tell me how I even get the filters off to begin with? Ty.

  4. #4
    Registered User
    Join Date
    02-03-2016
    Location
    Mount Gretna, PA
    MS-Off Ver
    2011
    Posts
    33

    Re: How to Keep the Order of a Filter

    Nm. I found it. Ty anyway.

+ 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. Filter Column doesn't arrange in number order
    By Article92 in forum Excel General
    Replies: 1
    Last Post: 10-23-2014, 04:32 PM
  2. Replies: 0
    Last Post: 02-15-2014, 10:30 AM
  3. Arrange in sequence order order whith selected filter
    By MAKEXAN12 in forum Excel General
    Replies: 9
    Last Post: 05-09-2013, 10:58 AM
  4. How to sum row in order to multiple variables filter
    By asada in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2012, 10:02 AM
  5. Changing order of entries in auto filter
    By nicolepag in forum Excel General
    Replies: 0
    Last Post: 01-09-2012, 01:46 PM
  6. Pivot table Filter order
    By OnlySteveH in forum Excel General
    Replies: 2
    Last Post: 09-28-2011, 07:20 AM
  7. Excel 2007 : Filter Dates - why not shown in order?
    By Chris001 in forum Excel General
    Replies: 0
    Last Post: 09-03-2009, 08:23 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