If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filters in Excel 2003
I am using Filters in Excel 2003.
Every cell in sheet B is linked to every cell in sheet A. That way I can alter data in B without corrupting the original data in A. I then highlight the cells in B that I want to assign a filter to and select Advanced Filter. I have no criteria so I do not set that. I click OK. I then select Filter again and this time select Auto Filter. Drop down arrows appear at the top of my columns. Great, no problems so far, I then select from the drop down list the criteria that I want to filter. Again no problems, my list filters correctly. But once I have done this I can not use the drop down lists to make another filter or select all to see all my data. Ether the drop down lists are not clickable or they disappear. What am I doing wrong? Thanks Steve |
#2
|
|||
|
|||
Filters in Excel 2003
I believe that you are doing everythig correctly. I have
an ancounter like that before. I think it has to do with Excel not being able to handle large tables. Try reducing the number of rows and try again -----Original Message----- I am using Filters in Excel 2003. Every cell in sheet B is linked to every cell in sheet A. That way I can alter data in B without corrupting the original data in A. I then highlight the cells in B that I want to assign a filter to and select Advanced Filter. I have no criteria so I do not set that. I click OK. I then select Filter again and this time select Auto Filter. Drop down arrows appear at the top of my columns. Great, no problems so far, I then select from the drop down list the criteria that I want to filter. Again no problems, my list filters correctly. But once I have done this I can not use the drop down lists to make another filter or select all to see all my data. Ether the drop down lists are not clickable or they disappear. What am I doing wrong? Thanks Steve . |
Thread Tools | |
Display Modes | |
|
|