Hi Vinod, There is no workaround to filter twice in one spreadsheet in Excel 2003.
Also,In Excel 2007, you will have to use "Format as table" style to apply filter to selected range. To use Format as Table, Just select the range and apply any table format from the dropdown and it will automatically apply filter to those selected ranges. I hope it helps. Please let me know if you have further doubts. Best regards, Ayush Jain Group Manager On Apr 11, 11:35 am, vinod rao <vinod.ma...@gmail.com> wrote: > Hi Ayush, > > I could put filter to one selected range and later when i want to put to > other range the 1filter disappeared. Note that i am using 2003. > > Regards, > > Vin > > On Sun, Apr 11, 2010 at 11:37 AM, Ayush <jainayus...@gmail.com> wrote: > > Hi Vinod, > > > It is very simple. Just select the 1st range and apply the filter and > > same for 2nd range. > > > Please let me know if you have more questions. > > > Best regards, > > Ayush Jain > > Group Manager > > > On Apr 11, 10:16 am, vinod rao <vinod.ma...@gmail.com> wrote: > > > Hi Vikas, > > > How did you do this?. > > > Regards > > > Vin > > > > On Wed, Apr 7, 2010 at 7:00 PM, Vikas Chouhan <vikask...@gmail.com> > > wrote: > > > > Hi, > > > > > Go format as table, > > > > > On Wed, Apr 7, 2010 at 6:23 PM, Jai <jaihumtu...@gmail.com> wrote: > > > > >> Dear All Members. > > > > >> How can put the filter 2 times in One Excel file . > > > > >> -- > > > >> Thanks For Mail. > > > > >> -- > > > ---------------------------------------------------------------------------------- > > > >> Some important links for excel users: > > > >> 1. Follow us on TWITTER for tips tricks and links : > > > >>http://twitter.com/exceldailytip > > > >> 2. Join our Facebook Group @ > > > >>http://www.facebook.com/group.php?gid=287779555678 > > > >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > >> To post to this group, send email to excel-macros@googlegroups.com > > > > >> <><><><><><><><><><><><><><><><><><><><><><> > > > >> HELP US GROW !! > > > > >> We reach over 6,800 subscribers worldwide and receive many nice notes > > > >> about the learning and support from the group.Let friends and > > co-workers > > > >> know they can subscribe to group at > > > >>http://groups.google.com/group/excel-macros/subscribe > > > > > -- > > > > One Team One Dream One Goal > > > > > Warm Regards, > > > > Vikas Chauhan > > > > E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, > > > > 9911868518, > > > > "We can't Spell S_ccess without U" > > > > > Life is Very beautiful !!! > > > > ¨`•.•´¨) Always > > > > `•.¸(¨`•.•´¨) Keep > > > > (¨`•.•´¨)¸.•´ Smiling! > > > > `•.¸.•´. > > > > > -- > > > ---------------------------------------------------------------------------------- > > > > Some important links for excel users: > > > > 1. Follow us on TWITTER for tips tricks and links : > > > >http://twitter.com/exceldailytip > > > > 2. Join our Facebook Group @ > > > >http://www.facebook.com/group.php?gid=287779555678 > > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > > HELP US GROW !! > > > > > We reach over 6,800 subscribers worldwide and receive many nice notes > > about > > > > the learning and support from the group.Let friends and co-workers know > > they > > > > can subscribe to group at > > > >http://groups.google.com/group/excel-macros/subscribe > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our Facebook Group @ > >http://www.facebook.com/group.php?gid=287779555678 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 6,800 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know they > > can subscribe to group at > >http://groups.google.com/group/excel-macros/subscribe > > > To unsubscribe, reply using "remove me" as the subject. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
