+ Reply to Thread
Results 1 to 3 of 3

What is the difference between "Format as Table" and "Sort and Filter"

  1. #1
    Registered User
    Join Date
    08-01-2014
    Location
    Melbourne Florida
    MS-Off Ver
    2010
    Posts
    3

    What is the difference between "Format as Table" and "Sort and Filter"

    What is the difference between "Format as Table" and "Sort and Filter"? My boss is asking me this quesiton and I do not know how to answer. I use the Format as Table and she likes the Sort and Filter. Thoughts please? Google didn't help any

  2. #2
    Forum Contributor
    Join Date
    01-29-2009
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    123

    Re: What is the difference between "Format as Table" and "Sort and Filter"

    Check this out. If all you want is sorting and filtering, both of them can do it and they work exactly the same. But if you are interested in quick formatting, quick summing, etc., a table would come in handy.

    http://www.techrepublic.com/blog/10-...-table-object/

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,517

    Re: What is the difference between "Format as Table" and "Sort and Filter"

    Format as a table will actually format the data as a table, sort and filter wont.
    If posting code please use code tags, see here.

+ 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: 01-02-2014, 02:15 PM
  2. Date format of just "st" "nd" "rd" and "th" with text included
    By notrandom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2013, 05:45 PM
  3. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  4. Filter report in pivot table with "greater than" and "less than"
    By gygabyte017 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-29-2012, 08:08 AM
  5. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM

Tags for this Thread

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