Viewing post #2080902 by Australis

You are viewing a single post made by Australis in the thread called Best spreadsheet.....
Image
Oct 3, 2019 9:13 PM CST
Plants SuperMod
Name: Joshua
Melbourne, Victoria, Australia (Zone 10a)
Köppen Climate Zone Cfb
Plant Database Moderator Forum moderator Region: Australia Cat Lover Bookworm Hybridizer
Orchids Lilies Irises Seed Starter Container Gardener Garden Photography
Yes, you can sort and filter in Google Sheets. The Data Menu has a lot of these options. The way I use it is to create a filter first on the entire spreadsheet (click on square above row 1 and to the left of column A to highlight/select the entire sheet, then select "Create a filter" from the data menu):

Thumb of 2019-10-04/Australis/177c8d

Once the filter has been created, there will be a little triangle on the first row (I also apply a colour background to the first row so that it's clearly the header row). Clicking on the triangle for any of the columns will bring up the sort and filter options for that column. So you can then sort the entire sheet by that column.

Thumb of 2019-10-04/Australis/4bb9d6
Plant Authorities: Catalogue of Life (Species) --- International Cultivar Registration Authorities (Cultivars) --- RHS Orchid Register --- RHS Lilium Register
My Notes: Orchid Genera HTML PDF Excel --- Lilium Traits HTML PDF --- Lilium Species Crosses HTML PDF Excel --- Lilium Species Diagram
The current profile image is that of Iris 'Volcanic Glow'.

« Return to the thread "Best spreadsheet...."
« Return to Irises forum
« Return to the Garden.org homepage

Member Login:

( No account? Join now! )

Today's site banner is by Lucius93 and is called "Bigleaf hydrangea"

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.