How To Make A Table In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to make a table in Google Sheets.

How To Make A Table In Google Sheets

It can take time to manually format tables in Google Sheets to get your data looking professional and easy to read.

Fortunately, Google Sheets has a built in feature to help you get your tables looking good with just a few clicks.

Even better, Google Sheets automatically handles formatting of new rows so you don’t have to worry about formatting each time you add data to the table.

Using Alternating Colors Format to Create Tables

The best way to format tables quickly in Google Sheets is to use the Alternating Colors formatting option. This option comes with a number of color presets, or you can set custom colors to get the exact look you want.

Follow these steps to format your table in just a few clicks:

Step 1

Select the range you want to convert to a table. Be sure to include the header row so Google Sheets can format that for you as well

Step 2

Open the Format menu and select the Alternating Colors option near the bottom

Step 3

In the sidebar that opens, select style from the list of default styles

Step 4

Or individually set colors for a custom style under custom styles

Step 5

When you’re happy with the colors, click Done. Your range will now be formatted as a table

Adding Data to Your Table

If you insert new rows or columns into the middle of your table, Google Sheets will automatically apply the table formatting to the inserted rows/columns so your table formatting still looks good.

You can even type new rows of data at the bottom of your table and they will be formatted as part of the table.

To do this, just start typing data into the first row below the table, and the table formatting will automatically be applied to that row


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to make a table in Google Sheets. Want more? Check out all the Google Sheets Tutorials.