answersLogoWhite

0

Select the block of cells you want to work on, including headings. Then go to the Data menu and pick Filter and then Advanced Filter.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

Why Microsoft Excel is dbms?

Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.Microsoft Excel is a spreadsheet application. While it does have some database capabilities, it is not a DBMS.


What are the two options provided in Microsoft Excel for filtering data?

AutoFilter 2. Advanced Filter Please click on the links to watch videos for more understating youtu.be/yfHs9kmaOiU youtu.be/EQBCOPdo4sA


What can Excel do in addition to its worksheet capabilities?

it can create charts


What are the differences between Microsoft Excel and Oracle Database?

Excel is a spreadsheet program. Oracle is for databases. Excel has some databasing capabilities, but it is not its main purpose.


Is Excel High School regionally accredited?

Yes, Excel High School is Regionally Accredited by AdvancED and the North Central Association. AdvancED and the North Central Association are recognized by the State and US Dept. of Education.


Where can one find advanced Excel tutorials online?

Advanced Excel tutorials can be found at websites, such as About, YouTube and eHow. These sites have advanced tutorials and videos that can be used to learn about the advanced functions in Excel.


Can recording data be done using a spreadsheet?

Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.Yes. In the sense of keeping a record of data, Excel can do that. It deals mainly with numerical data, but it can be used for other kinds of data. It has databasing capabilities, though to do a proper database, another application would be better. Excel is primarily a spreadsheet, not a database.


In Microsoft Excel when you filter data it shows only data that meets certain criteria?

Yes. Filtering data allows you to see on certain parts of it, based on the criteria you have specified. It is one of the things that a database does, but Excel can also do.


What other module in office 2007 has database capabilities beside access?

Excel has limited capability to act as a database.


What is the Microsoft version of Excel before 2013 came out?

Microsoft Excel 2010.


Do you have experience in Excel such as VLOOKUP and other more advanced features?

This is a question that could be asked at an interview. To answer yes, you would need to have a good knowledge of Excel. There are a lot of specialised functions, such as VLOOKUP, that more advanced users can work with. For a job that has a lot of Excel involved it would be a good idea to look at the more advanced features, such a VLOOKUP and many other functions that a lot of ordinary users know little about. Excel has hundreds of functions and most people only know a small amount of them.


Does Excel offers data integrity?

Excel is not a full working database. It only has some databasing capabilities. If you want to ensure data integrity you are better to look at using an actual database application.