Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help - Very easy Question
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

5 Posts

Posted - 12/12/2012 :  13:19:48  Show Profile  Reply with Quote
Hello I am not good at excel 2007.

How do I filter a column in excel 2007 the way i would in SQL?

Lets say I do not want to see certain values.

In SQL i would say

select ***********

NOT IN('a','b','c')

How do I accomplish this task in Excel 2007?

Posting Yak Master

103 Posts

Posted - 12/12/2012 :  13:35:28  Show Profile  Reply with Quote
Highlight the cells that will be sorted
Click the Sort & Filter button on the Home tab
select the one you want to filter
Go to Top of Page

Starting Member

7 Posts

Posted - 12/13/2012 :  02:17:31  Show Profile  Reply with Quote
select Data in the top of Excel book. you will find Filter icon in the ribbon.

Select the column you want to apply filter, then click the filter icon from the ribbon.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000