Archive

Posts Tagged ‘Google Spreadsheet’

AutoFilter in Google Docs Spreadsheet

November 5th, 2010 No comments

My first complain when I started using Google Docs as my primary Office Suite is the lack of an Auto Filter.

These are the options:

-There is the option to use a filter by changing to List View with Menu View>ListView but it’s quite limited.

-There is a built-in function to filter a range and return the results in a new range.  That might be useful for certain situations, but not for my general usage.

-And the winner is:

Someone has already solved this problem programming a script that does the trick, is not the perfect solution, but is definitivelly the best. To use it, go to the Menu at Tool>Scripts>Insert… and then look for it in the business section.

The best part is that  now I know that scripting is possible in Google Docs.

SocialTwist Tell-a-Friend
Categories: software, websites Tags: