3 Ways to Format Tables in Google Sheets

Parth Shah is an evergreen freelance writer covering how-tos, app guides, comparisons, listicles, and troubleshooting guides on Android, iOS, Windows, Mac, and smart TV platforms. He has over five years of experience and has covered 1,500+ articles on GuidingTech and Android Police. In his free time, you will see him binge-watching Netflix shows, reading books, and traveling.

Atish is a seasoned tech enthusiast fueled by caffeine and a Computer Science engineering degree. He stumbled into the blogging world in 2015 and hasn’t looked back. Over 2000+ articles later, his work has been featured on sites like Gizbot, Firstpost, PhoneArena, GSMArena, and IBTimes. At GT, he’s your go-to guy for how-tos, invaluable tips, and troubleshooting guides that actually work. He’s also an SEO and digital marketing whiz and content strategist, so his tech takes are always on point and ethical.

Method 1. Change Table Colors

Step 1:Open a spreadsheet inGoogle Sheets.

Step 2:Once you are done adding entries and making tables, click onFormatat the top.

Step 3:SelectAlternating colors, and it will open a side menu.

Step 4:Click on thelittle iconbeside the current range and select acustom rangeto apply colors.

Step 5:Select one of thedefault styles, and you will instantly see a new style in action.

You can even change the header, color 1, color 2, and footer theme to your preference. Once you make changes in default styles, it will be saved as a custom theme so that you can use it in the future with a single click. Hit theDonebutton and enjoy your spreadsheet in a colorful avatar.

Method 2. Use Themes

Step 1:From Google Sheets, selectFormatin the menu bar.

Step 2:Click onThemesfrom the drop-down menu.

Step 3:Check a bunch of default themes from the right sidebar.

Step 4:Select yourpreferred themeand check the new color in action.

If you don’t prefer anything from the list, select any theme and click onCustomizeat the top.

The following menu will help you change font type, text color, chart background, color, hyperlink color, and edit different accent colors in a theme. Hit theDonebutton, and you are good to go.

Method 3. Use Table Styles Add-on

Using a third-party add-on called Table Styles, you can change the look of the spreadsheet on the go. First, we will show you how to install Table Styles in your Google Sheets account and check the add-on in action.

Step 1:From Google Sheets, click onExtensionsat the top.

Step 2:Open theAdd-onsmenu and selectGet add-ons. It will open the Google Workspace Marketplace.

Step 3:Use the search bar at the top and search forTable Styles.

Step 4:InstallTable Stylesin Google Sheets.

Now that you have installed Table Styles, let us show you how to use the add-on to format tables in Google Sheets.

Step 5:Once you open a spreadsheet, selectExtensionsin the menu bar.

Step 6:ExpandTable Styles> click onStart.

You will see Table Styles in action from the right-side menu. Unlike the default Alternating colors option in Google Sheets, Table Styles won’t automatically detect a table in Sheets. You need to select the cell range manually. We have selected B27:F38 to format in Google Sheets in the example below.

Select one of the themes from Table Styles. The extension offers several styles to choose from. You can change the style with lighter, darker, or contrast colors.

Besides changing the header row and footer and implementing alternating colors, Table Styles will change the left and right column colors.

You can expand the Preview & edit option and check the format in action before applying it to Google Sheets. Once you are satisfied with the preview, hit theStylebutton at the bottom.

Was this helpful?

Last updated on 23 August, 2024

Leave a ReplyCancel reply

Your email address will not be published.Required fields are marked*

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Internet and Social

Why Is TikTok Lagging on Android or iPhone and How to Fix It

How to Disable Tumblr Safe Mode or Bypass it Without an Account

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.