Created Table in Google Sheets

Google Sheets does not have a built-in data table like Microsoft Excel does. This works as an alternative table in Google Sheets that replicates Microsoft Excel's features as best as possible. The table can be colored and sorted by color, value, or A-Z.

1. Laptop or device with internet access
2. Google account
3. Google sheets document with data

Ensure list categories are set up, as you want them, on your table. The location of the actual data is not important as it can be moved around by sorting later.

2.1. Highlight Data Set

2.2. Click “Format” in the toolbar

2.3. Click “Alternating Colors” in the format tab

2.4. Choose the Color you want for your table

Although the coloring has no intrinsic function for the table, it is aesthetically pleasing and creates a more polished look. Skipping this step won’t affect the table’s functionality.

3.1. Highlight table

3.2. Click “Data” in the Toolbar

3.3. Click “Create Filter” in the data tab

This step creates the filter feature that allows you to sort the data in your table. To sort the data, click the three lines on the title of the category you wish to sort, and select how you want the data sorted.

Step 4.1. Highlight piece of data

Step 4.2. Click the paint bucket on the bottom tool bar

Step 4.3. Select the color you want to make the piece of data

By coloring the data, you can now access the “sort by color” feature on the data filter.