How to use and customize a theme in Google Sheets – Guide

We can change the Office theme to “Homespun” by going to the Theme Colors section and selecting “Homespun” as the color.

To choose theme colors, open the spreadsheet and click on the Edit button in the color palette. In the color sidebar, select a color from the list to start editing.

apply a theme

Excel allows users to change the theme of a workbook, which can affect the formatting and appearance of data. The default theme in Excel is “Office,” but users can select from a variety of other themes. For example, suppose we have data in a spreadsheet that is formatted as a blue table with the title in blue font, using Calibri fonts by default. We might want to change the theme to one of the other themes offered in Excel, such as “Nature” or “Retro.” ..

On the ribbon, click Themes, and choose an offered theme (eg Slice). Applying the Slice theme changes the cell, object, and table formatting. The font is now Century Gothic, the Word Art font color is orange, and the table background colors are different shades of blue than they were using the Office theme.

change a theme

You can change the layout of your spreadsheet using the Excel Ribbon. You can change the color scheme, font family, and elements such as the color of cells and borders.

Change the color scheme

  1. Open the System Preferences app and select the Appearance tab.
  2. Scroll down to the Colors section and change the color of the Keyboard bar to black.
  3. Close System Preferences and reopen it.

On the Page Layout tab, in the Themes group, click Colors > Customize Colors. On the Page Layout tab, in the Themes group, click Colors > Customize Colors. In the Customize Colors dialog box, under Theme Name, type Ribbon and under Color Scheme Name, type Dark Gray. Under Background Color, type #000000. Click OK. ..

In the pop-up window to change theme colors, you can change the color of different categories. We will change Accent 1, which will affect the table.

  1. Choose the accent color and name the adjusted color scheme.
  2. Press Save to create your new scheme.

After that, the colors of the entire workbook are adjusted according to these changes. As you can see in the image below, the table colors are changed from blue to orange.

change font

  1. Open the Fonts panel in the System Preferences window.
  2. In the Fonts section, select a new font and click the Change Font button.
  3. In the New Font dialog, enter a name for the new font and click OK.
  4. Close the Fonts panel and reopen System Preferences to apply the new font.

On the Page Layout tab, click Fonts in the Themes group. Choose Customize Fonts. Select the text you want to change font for, and then choose a new font from the list. ..

In the pop-up window, set up a font for the title or body text. For this example, (1) set the body font to “Warning”. Now (2) name the modified font settings (eg “Custom Font”). Save it.

You can see how the color and font changed as per the theme customization in the image below.

Save custom theme

If you want to use the tweaked theme later and/or in other Excel workbooks, save it as a custom theme.

To change the look of your blog’s pages, go to the Page Layout tab and choose Themes. From there, you can select a different theme to use for each page. ..

In the pop-up save window, choose a name for the custom theme (eg “Custom Theme”). The theme will be saved as a file in .thmx format.

If you want to use a custom theme in an Excel workbook, you can do so by opening the File menu and choosing “Open in new window.” Then select the “Microsoft Document Themes” folder and click on the “Themes” tab. There you will see a new section called “Custom Themes.”

Change and customize the theme in Google Sheets

  1. Open Google Sheets and click on the three lines in the top left corner of the screen.
  2. On the left side of the screen, select “Tools” and then “Google Sheets.”
  3. On the right side of the screen, select “Theme.”
  4. In the Theme box, select a different theme.

In the Format > Theme dialog, select the “Menu” style.

On the right side of the screen, there are different themes to choose from. As a result, the chart’s theme changes. ..

You can also customize the selected theme

To change the default theme, open the Themes window and click Customize. ..

You can now change the font style, graphic backgrounds and texts. To do this, you first need to open the Fonts dialog box by clicking on the Fonts button in the main window of your browser. Then, select a new font from the list and click on the OK button to close the Fonts dialog box.

Final note

Google Sheets is a great tool for data analysis, but it can be difficult to customize the look and feel of the interface. This guide will show you how to use themes to make your sheets look and feel more like the ones you see on professional websites. ..