+ Reply to Thread
Results 1 to 3 of 3

Filters

  1. #1
    Registered User
    Join Date
    09-25-2009
    Location
    manchester, england
    MS-Off Ver
    Excel 2007
    Posts
    2

    Filters

    Can anyone help with a filtering issue I have in 2007.

    I am making a spreadsheet for purchase requisitions and need to have a number of filters on different data. When I try and apply these it only lets me put one filter on the page.

    Or is there another way of selecting muliple data from eg drop down lists so that people cannot enter wrong information?

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: Filters

    Hi & Welcome,

    Or is there another way of selecting muliple data from eg drop down lists so that people cannot enter wrong information?
    Yes there is. Take a look at excel help under "Data Validation" - there's many options, one or more of them should suit your requirements.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    09-25-2009
    Location
    manchester, england
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Filters

    Ta Muchly - I shall try this forthwith

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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