answersLogoWhite

0


Want this question answered?

Be notified when an answer is posted

Add your answer:

Earn +20 pts
Q: In AutoFilter what are the '' and '' used for?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the shortcut key to get Autofilter in Excel?

Ctrl+Shift+L (or) Alt + D + F + F That will open the Data>filter>autofilter Display the AutoFilter list for the current column Select the cell that contains the column label, and then press ALT + DOWN ARROW Close the AutoFilter list for the current column ALT + UP ARROW Select the next item in the AutoFilter list DOWN ARROW Select the previous item in the AutoFilter list UP ARROW Select the first item (All) in the AutoFilter list HOME Select the last item in the AutoFilter list END Filter the list by using the selected item in the AutoFilter list ENTER


What excel feature can be used to easily locate rows in a table?

Filter and its associated command Autofilter.


Does a filter arrow on a column indicate that it is an Excel table?

It can indicate a table or that AutoFilter is on.


What is a benefit of using the AutoFilter option?

It allows you to view only the neccesarry data. <plato>


What excel feature locates rows in a table that meet a criteria?

Filter and its associated command Autofilter.


When working with a workbook of data on sales representatives and their office location which of the tasks can excel's autofilter heop you to perform?

sales


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 is Autofilter in Microsoft Excel?

The Autofilter function looks at all the contents in a column and allows you to select only those entries you want to see. It provides a drop down list containing one copy of each of the different values. You can then select which ones you want to see by clicking on the values in the drop down list.


How do you put a multiple filter in Microsoft Excel spreadsheet?

It is not possible to have multiple autofilters in one worksheet. What you can do is select your range(s) and convert them to a list/table by going to Data->List in Excel 2003 or Insert->Table in Excel 2007. This will give you the functionality of an autofilter, but it can be applied to several ranges within the same worksheet.


I would like to print a monthly calendar with my clients renewal dates and contacts how can i enter them in so I can print off the next months activities?

Input everything to an excel sheet. Dedicate a column for each dates, months and years (don't write them in one cell). Once done inputing select everything goto data autofilter Now you can filter them with months.


What is a filter arrow in MsExcel?

If you have a database-type table in Microsoft Excel, with a row of column headers at the top of the table, you can turn on "autofilter" to display filter arrows next to the elements in the header row. If you click the arrow, you can select one item and the list will be filtered so that only rows that match the selected entry will be displayed. It's a quick and easy way to display only the desired elements from your database.


How can you filter an Spreadsheet Table by Color in Kingsoft Office?

Filter by cell color, font colorFollow these steps to filter data by cell color / font color.Step 1 Open a worksheet with Spreadsheets 2013.Step 2 Select the range of cells you want to filter.Step 3 Go to Home or Data tab, click on Autofilter.Step 4 Click on the drop-down arrow in each cell of the first line in the selected range. In the autofilter option .