Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: how to do Excel Like Filtering in Open Office


28 Jun 2012   #1

Windows 7
 
 
how to do Excel Like Filtering in Open Office

Hello , i am new to open office .. i used excel 2007 earlier...
i like to know is excel 2007 type tick filtering is available on open office.... if yes how to do it..

if no ... please tell me what is the alternative way to do that kind of filtering in open office

My System SpecsSystem Spec
.

28 Jun 2012   #2

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

In LibreOffice which is pretty much like OpenOffice it is Data->Filter->Auto Filter...
My System SpecsSystem Spec
28 Jun 2012   #3
Azo

Windows 7 Home Premium 64Bit
 
 
Easy !

In openOffice the easiest way to filter your data is to use the inbuilt autofilter feature. To do this, you’ll need to select the cells you want to filter.

Let’s click the upper left corner of the sheet to select the entire worksheet. Next, select the data menu then choose filter, autofilter.



You may see a message stating “The range does not contain column headers. Do you want the first line to be used as column header?”
In this case, the first line of the selected range functions as a column header so you can click the yes button.
Suppose you wanted to only view items that belong to the category of deciduous shrubs.





Click the auto filter menu button in the category column. Then select deciduous shrubs from the drop down menu. Now only deciduous shrubs are displayed.
You can filter further if you want to. Imagine you only want to show deciduous shrubs that have a medium growth rate. Just click the autofilter dropdown button in the growth column and select medium. Now you only see deciduous shrubs with a medium growth rate.
To remove the filter, select the filter option from the data menu, then choose remove filter.


Source:Free OpenOffice Calc tutorials - Filtering data
My System SpecsSystem Spec
.


29 Jun 2012   #4

Windows 7
 
 

Thanks a lot guys.... i will go for libreoffice ... hope open office will also add this feature in their coming version........
My System SpecsSystem Spec
29 Jun 2012   #5
Azo

Windows 7 Home Premium 64Bit
 
 

Quote   Quote: Originally Posted by mnr367 View Post
Thanks a lot guys.... i will go for libreoffice ... hope open office will also add this feature in their coming version........
It's already there in OpenOffice and I just showed you how to do that !
My System SpecsSystem Spec
29 Jun 2012   #6

Windows 7
 
 

Quote   Quote: Originally Posted by Azo View Post
Quote   Quote: Originally Posted by mnr367 View Post
Thanks a lot guys.... i will go for libreoffice ... hope open office will also add this feature in their coming version........
It's already there in OpenOffice and I just showed you how to do that !
ya thank you.... but in that i can't filter multiple items.... that's why
My System SpecsSystem Spec
29 Jun 2012   #7
Azo

Windows 7 Home Premium 64Bit
 
 

Quote   Quote: Originally Posted by mnr367 View Post
Quote   Quote: Originally Posted by Azo View Post
Quote   Quote: Originally Posted by mnr367 View Post
Thanks a lot guys.... i will go for libreoffice ... hope open office will also add this feature in their coming version........
It's already there in OpenOffice and I just showed you how to do that !
ya thank you.... but in that i can't filter multiple items.... that's why
Is this what you are searching for: OpenOffice Calc Tips : Data Filtering : Advanced Filter
My System SpecsSystem Spec
29 Jun 2012   #8

Windows 7
 
 

Advance Filter is what i was looking for... but i find it a little complicated... so thats why i like the tick filtering in Excel and LIbre... that's very easy to use
My System SpecsSystem Spec
Reply

 how to do Excel Like Filtering in Open Office




Thread Tools



Similar help and support threads for2: how to do Excel Like Filtering in Open Office
Thread Forum
Open Excel file to directly open from IE9 Microsoft Office
Open Excel file to directly open from IE9 Microsoft Office
Open Office, And MS WORD/EXCEL Questions Microsoft Office
How to open 2 excel files side by side in Office 2010? Microsoft Office
Office 2010(Win7, 64bit) won't open Office 2007(WinXPr3 32 bit) files Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 12:01 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33