« Printing only non-zero values | Main | DataPilot 101 »
September 28, 2004
Data Filtering : AutoFilter
When you have a list of items, you can filter out records that meet a particular criteria. This is a quick introduction to some of the OOo Calc data filtering capabilities.
First, select the columns and rows that you would like to filter. Then Data-Filter-AutoFilter as shown below.
This is the result. You should now see drop-down arrows at the head of each column.
Clicking on any of the drop-down arrows gives you several options, you can click on any of the sample data or use one of the specialized filtering tools listed. If a list is previously filtered, you can click on the (All) option to bring back the records. For example, we'll click the arrow to the right of Month and choose Jan out of the list.
Only the rows that meet the selection criteria are now visible. Don't worry, you can restore the original table just as easily as you filtered it.
Posted by Dave at September 28, 2004 07:26 AM
Comments
Hi,
I would like to know if there the spreadsheet has a option in
data->filter->autofilter
there is no custom option which is present (it has all, standard, top 10) can u suggest any plugin or an addon so that I can use that option.
Thanks in advance
Posted by: JP at October 26, 2004 10:15 AM
You may want to consider the standard or advanced filter options that are also available. I have published introductions to these elsewhere on this site.
Posted by: richhill at October 26, 2004 05:06 PM
Is there a way to do this (filtering) with a macro?
Posted by: BADGE at August 17, 2005 01:49 PM
if we filter the first column the second column filter values are not coming accordingly, instead it shows all the values. so it is difficult to filter it.
Posted by: Prabhakaran.M at March 6, 2006 02:15 AM