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
mnr367

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
kado897

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
mnr367

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
mnr367

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
mnr367

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
Thread Forum
Error on saving MS Office Excel 2007 files to MS Office 2013
We have an upgrade on our computer units here in the company, my problem is when users save their 2007 excel files an error pops up, Errors were detected while saving "File Name". Microsoft maybe able to save the file by removing or repairing some features. To make the repairs in new file, click...
Microsoft Office
Open Excel file to directly open from IE9
Hello guys, I wanted to open an excel file directly from IE9, but when I double click the excel file in the browser, it opens right in IE instead of Excel program. How do I make the file use Excel program to open rather than open in IE itself? I am using Windows 7 and Office 2010. I tried the...
Microsoft Office
Open Office, And MS WORD/EXCEL Questions
Hello, Great Forum. Wonderful, knowledgeable folks. Had to re-format HD, and seems to be working now. But for how much longer, who knows. On the old setup, I had MS WORD and Excel. Many existing files of both.
Microsoft Office
How to open 2 excel files side by side in Office 2010?
How can I open 2 excel files side by side in Office 2010?
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
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 05:19.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App