Last Updated on November 1, 2023 by Jake Sheridan
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:
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
Open the Format menu and select the Alternating Colors option near the bottom
In the sidebar that opens, select style from the list of default styles
Or individually set colors for a custom style under custom styles
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.
More ways to design in Google Sheets:
- Add Borders
- Add A Line
- Add A Tab
- Change Default Font
- Change Cell Color
- Alternate Colors
- Color Code
- Make Cells Bigger
- Make A Button
- Get Rid Of Lines
- Remove Borders
- Bold Lines
- Make Paragraph
- Set Margins
- Make A Header
- Make Categories
- Make A Template
- Shift Cells Down
- How Many Sheets Can You Have?
- Create A Header
- Content Calendar
- Make All Cells The Same Size
- Outline Cells
- Remove Cell Lines
- X Out A Cell
- Group Cells
- Format Cells
- Add Serial Number