Working with multiple tables, charts, and cells in a long spreadsheet can get tedious. Additionally, you can highlight a specific row or column for emphasis in a Google Sheets document. Google Sheets has many formatting options to make those tables look good.
You can use the default formatting options, use themes to add life to those charts, or choose an add-on to make changes. Let us show you how to easily format tables and charts in Google Sheets.
1. Change the palette color
Google Sheets has default formatting options for changing header, footer, and cell colors. Check it out in action.
Step 1: Open the spreadsheet in Google Sheets.
Step 2: Once you’re done adding the entries and creating the table, click Format at the top.
Step 3: Select Alternating Color (although the naming might be better here) and it will open a side menu.
Step 4: Click the small icon next to the current range and select the custom range to which you want to apply the color.
Step 5: Choose one of the default styles and you’ll immediately see a new style 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 raw theme white and the other light colored so that there is enough separation between the two.
You can even change the header, color 1, color 2 and footer themes to your preference. When you make changes in the default style, it will be saved as a custom theme so you can use it in the future with just one click. Hit the Done button and enjoy your spreadsheet in a colorful avatar.
2. Use Themes
The most useful themes to make those bar and linear charts more attractive. You can completely change the look of your added charts in Google Sheets with just one click. This is the way.
Step 1: From Google Sheets, select Format in the menu bar.
Step 2: Click Theme from the drop-down menu.
Step 3: Check out a bunch of default themes from the right sidebar.
Step 4: Choose your favorite theme and test the new color in action.
If you don’t like anything from the list, you can choose any theme and click customize at the top.
The following menu will help you to change font type, text color, chart background, color, hyperlink color and edit different accent colors in a theme. Hit the Done button and you’re ready to go.
3. Use Table Style Add-ons
If you don’t like Google’s services, third-party add-ons are here to save you. Using a third-party add-on called Table Styles, you can change the look and feel of your spreadsheet on the go. First, we’ll show you how to install Table Styles in your Google Sheets account and test the add-on in action.
Step 1: From Google Sheets, click on Extensions at the top.
Step 2: Open the Utilities menu and select Get add-on.
Step 3: This will open the Google Workspace Marketplace. Use the search bar at the top and search for Table Styles.
Download Table Styles in Google Sheets
Step 4: Install Table Styles in Google Sheets.
Now that you have Table Styles installed, let us show you how to use the add-on to format tables in Google Sheets.
Step 1: When you open the spreadsheet in Google Sheets, select Extensions in the menu bar.
Step 2: Expand Table Styles and click Start.
You will see Table Styles in action from the menu on the right. Unlike the default “Alternate Color” option in Google Sheets, Table Styles will not automatically detect tables in Sheets. You need to select the range of cells manually. We chose B27:F38 for formatting in Google Sheets in the example below.
From Table Styles, choose one of the themes. The extension offers several styles to choose from. You can change the style with lighter, darker or contrasting colors.
In addition to changing the header and footer, and implementing alternating colors, Table Styles will even change the left and right column colors.
You can expand Preview & edit options and check the formatting is working before you apply it to Google Sheets. Hit the Style button at the bottom when you’re satisfied with the preview.
Create eye-catching Google Sheets spreadsheets
Your Google Sheets spreadsheet doesn’t have to be bland all the time. With the right amount of formatting options in Sheets, you can make changes to tables and charts to make them easier to see.
Categories: How to
Source: thpttranhungdao.edu.vn/en/
