Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Horizontal Filter

  1. #1
    Join Date
    30th March 2005
    Posts
    78

    Horizontal Filter

    Is it possible to have a horizontal filter? if so how? I have a spread sheet in which i have verticle filter setup through the auto filter funtion. I would now like a horizontal filter to show only specific cloumns. How do i do this?

    Thanks in Advance

    Anuj

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st February 2003
    Location
    Memphis, TN
    Posts
    891

    Re: Horizontal Filter

    I think you may want to look at a Pivot Table. This will give you more options as to what data to display.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    30th March 2005
    Posts
    78

    Re: Horizontal Filter

    I am not too sure on how to do this, can you explain please?

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    14th July 2004
    Location
    Berkshire UK
    Posts
    426

    Re: Horizontal Filter

    Start the Pivot Table Wizard by selecting Data on the Toolbar then Pivot Table and Pivot Chart Report, then follow the wizard's instructions. The date must be in a contiguous set of rows and columns and all columns must have a heading. Column row and data fields are created by dragging icons into the template

    Happy pivoting

    Robert

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    26th August 2012
    Posts
    1

    Re: Horizontal Filter

    Column Filter is now available in Excel which can filter data Horizontally same as Auto filter that filters rows Vertically :
    Visit http://www.excelolozy.com/2012/08/ColumnFilter.html , Any thing in Excel, It's Excel-o-lozy... www.Excelolozy.com

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    9th April 2007
    Location
    Alstonville, Australia
    Posts
    3,497

    Re: Horizontal Filter

    Hi amit01024
    Thanks for the info but the thead is seven years old
    Can you please only post in current threads
    If the solution helped please donate to RSPCA

    Sites worth visiting: Rabbitohs | Excel-it royUK | Golden Rules | Forum Rules | Freebie Stuff | Smallman Freebies

    Ozgrid Free Excel Training

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. vertical to horizontal
    By pytelium in forum EXCEL HELP
    Replies: 2
    Last Post: June 4th, 2006, 07:58
  2. Horizontal to Vertical or Vertical to Horizontal?
    By docchang in forum EXCEL HELP
    Replies: 1
    Last Post: February 16th, 2005, 01:16
  3. Horizontal to Vertical Text
    By braveheart in forum EXCEL HELP
    Replies: 2
    Last Post: August 13th, 2004, 20:51
  4. Vertical/Horizontal Analysis
    By tjtumlin in forum EXCEL HELP
    Replies: 3
    Last Post: March 5th, 2003, 01:51

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
  •  
porno