How To Create a Table in Google Sheets

Опубликовано: 22 Март 2026
на канале: Cogwheel Learning

164,618

867

In this tutorial, I will show you how to create a table in Google Sheets .

There is no option in Google Sheets to make a table like the Format as Table option from Excel.

However, we can apply some formatting tips to create a table in Google Sheets.

You can do this manually, but it’s way easier and quicker to do with the Alternating Colors tool under the formatting menu.

Simply highlight your whole table and then open up the Alternating Colors option sidebar. Select the color scheme you want, whether you have a header or footer row, and even choose custom colors if you wish.

Also, you can create a fileter by going to the data menu and select 'Create a filter' option.

Now, this is an option to get as close as possible to a table in Google Sheets.

If you find this useful, please drop a 👍 on the video and subscribe 🥰

Timestamp:
00:00 Intro
00:26 Format a table
01:02 This is how you do it!

🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions:    • 💰 Compound interest calculator template in...
🎥 Common errors:    • 🚨 How to solve the #DIV/0! error in Excel
🎥 How to tutorials:    • How to use UPPER in Excel
🎥 Regular functions explained:    • BASIC EXCEL FUNCTIONS

Feeling generous? I like coffee.🤗
☕ https://www.buymeacoffee.com/cogwheel