Working with multiple tables, charts, and cells can become a chore. long spreadsheet Boring. Also, you can highlight a specific row or column to emphasize it in a Google Sheets document. Google Sheets offers ample formatting options to make these tables look great. You can either use the default formatting options, use themes to add some life to those charts, or choose an add-on to make changes. Let's show you how to format tables and charts in Google Sheets without further ado.
1. Change table colors
Google Sheets has default formatting options for changing header, footer, and cell colors. Let's see this in action.
Step 1: Open spreadsheet in Google Sheets.
Step 2: Once you have finished adding entries and creating tables, click Coordinate above.
Step 3: Locate Alternative colors (Maybe the label would be better here), and it will open. Side menu.
Step 4: Click microcode Next to the current range, select custom domain You want to apply colors to it.
Step 5: Locate One of the default patterns , and you'll immediately see a new pattern in action.
To separate them from the group, you can apply a dark theme color to the header and footer. The default themes are designed to keep one plain white and the other a light shade to provide sufficient separation between the two.
You can even change the header, color 1, color 2, and footer theme to your liking. Once you make changes to the default styles, they'll be saved as a custom theme so you can use them in the future with just a click. Hit the Done button and enjoy your spreadsheet in a colorful avatar.
2. Use of topics
Themes are especially useful for making bar and line charts more attractive. You can completely change the appearance of charts added to Google Sheets with just one click. Here's how.
Step 1: of Google Sheets , Locate Format in menu bar.
Step 2: Click Features from the dropdown menu.
Step 3: Verify A set of default features From the right sidebar.
Step 4: Locate Your favorite look and check out New color running.
If you don't prefer anything from the list, you can select any theme and click Customize at the top.
The following menu will help you change the font type, text color, chart background and color, hyperlink color, and edit various highlight colors in the theme. Click the Done button, and you're good to go.
3. Use additional table styles
If you don't like Google's view, third-party add-ons are here to save the day. Using a third-party add-on called Table Styles, you can change the appearance of your spreadsheet on the go. First, we'll show you how to install Table Styles in your Google Sheets account and check if the add-on is working.
Step 1: of Google Sheets , Click Extensions At the top.
Step 2: Open Add-on List And specify to get extra jobs.
Step 3: will open Google Workspace Marketplace. use Search bar At the top and search for Table Styles.
Download table styles in Google Sheets
Step 4: Installations Table Styles in Google Sheets.
Now that you have installed Table Styles Let us show you how to use the Table Formatting add-in in Google Sheets.
Step 1: Once opened spreadsheet in Google Sheets , Locate Extensions in the menu bar.
Step 2: Expand Table styles And click Start.
You'll see Table Styles turned on from the menu on the right side. Unlike the default "Alternate Colors" option in Google Sheets, Table Styles in Sheets won't automatically detect the table. You need to manually select the cell range. We've selected B27:F38 for the format in Google Sheets in the example below.
From Table Styles, select One of the featuresThe extension offers several styles to choose from. You can change the style to lighter, darker, or contrasting colors.
Aside from changing the header and footer row and implementing alternate colors, table styles will change the colors of the left and right column.
Create eye-catching spreadsheets with Google
Your spreadsheets in Google Sheets don't have to be pretty all the time. With the right amount of formatting options in Sheets, you can make changes to your tables and charts to make them more visually appealing.
