Add a table to Google sheets

Select your data

Select ‘Create a Filter’

You can now select the drop down menu in the header row and sort by different methods.

You can then go on to set alternating colours on the table by selecting the data, Format and then Alternating colors.

Leave a Reply