fsa tip #74 – Navigate your crop plan with filters

How to navigate your crop plan data with the Filter Tool in Google sheets.

You can watch the video here.

Here are the basic steps

1️⃣  Highlight all your data (CMD-A or CTRL-A)

2️⃣  Click CREATE A FILTER in the menu toolbar

3️⃣  Inverted triangles appear in the headers of your columns

4️⃣  Click on the triangles and filter away

PIVOT TABLES vs FILTERS

Recently we looked at Pivot Tables – Pivot Tables create a completely different report on a different page, This is great for greetings schedules and lists.

The filter tool does something different. It lets you manipulate the actual information in the spreadsheet. This way you can quickly drill down to the rows that you need to work with.

There are similar tools in Excel and other spreadsheet apps.

Watch The Crop Plan Workshop


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s