Buy Now

Change Cell Styles In Google Sheets Quickly and Easily

Mar 20, 2023

Do you want to learn how to change cell styles in Google Sheets to make your spreadsheet easy to read and view?

It is essential to ensure your data looks friendly and organized when using Google Sheets. This article will show you how to change the styles of cells in a Google Sheet. You can change the text, colors, borders, and more.

Here, we will discuss the following:

  • Merging cell borders.
  • Changing the row size.
  • Adjusting the font size.
  • Formatting the font.
  • Formatting the text color.
  • Setting the texts in bold.
  • Formatting the text alignment.
  • Formatting the border style.
  • Format cells using the Fill Color option.
  • Formatting numbers.

Read Also: Excel IFERROR Function With Formula Examples

Change/Format Cell Styles.

To change your cells styles, follow the steps below for each formatting option:

Merge cell borders.

Choose the cells you want to merge by selecting the cell row range and clicking the Merge cell option. Do the same thing for row 2.Merge cell option.

Change the row size.

  1. To change the selected entire row, click one row, press CTRL, like the other row, and drag them downwards.Selected rows.

  1. After dragging the selected rows downwards, it will increase its size.Row size changed.

Change the Font size.

  1. Select a cell and go to the Format Option.Format tab.

  1. In the Formatting menu, click the Font Size option, and choose a Font size number.Font size option and Font size number.

Format Font.

  1. Select the Google Sheets cells you want to format the font and click the Font Option.Font Option

  1. Choose a Font Style you want, which will change to a new font of the selected cell.Font Menu

Format Text Color.

  1. Choose the cell you want to change the text color.Change text color.

  1. Select a color, and the chosen color will change the text color of the selected cell.Text Color Menu.

Text Bold.

  1. Select the cells you want to turn in Text Bold and click the Text Bold button in the toolbar.Bold text button.

  1. The selected cells will become bolded. Bolded text.

Format Text Alignment.

  1. Select the cells you want to align and click the Horizontal Alignment button in the toolbar.Horizontal Alignment Option

  1. Select a horizontal text alignment that will align your selected cell.Horizontal Alignment Menu.

  1. Now select a vertical text alignment by clicking the vertical alignment button in the toolbar.Vertical alignment.

Format Border Style.

  1. Select all of your data and click the Borders button in the toolbar in your Google spreadsheet.Add Borders option.

  1. Select a border style in the cell borders menu, and you can also choose a border color by clicking the border color option.Borders option.

Format cells using the Fill Color option.

  1. Select a single cell or how many cells you want and click the Fill color button in the toolbar.Fill color option.

  1. In the Fill Color option, you can choose a color you want, and it will fill the color of the selected cell.Fill color menu.

Formatting Numbers.

  1. To format numbers, select the cells containing numbers and click the format as currency.Format Number as Currency.

  1. It will format the numbers into currency.

    Formatted number as curency.

  1. If you want more Number Formats, go to the Format tab, select Number Format Menu, and you can choose number formats based on your data.Format Number Menu.


Read Also: How to Wrap Text in Google Sheets

Final Thoughts on How to Change Cell Styles In Google Sheets.

Formatting cells in your Google Spreadsheet is relatively easy. Following the steps above, you can make your data representation easy to understand, view, and, most importantly, organized.

For more easy-to-follow Google Sheets guides, visit Simple Sheets. Get Excel and Google Sheets templates by reading the related articles below!

Frequently Asked Questions on Change Cell Styles In Google Sheets:

Can I clear/ reset my formatting/styles in Google Sheets?

To make the formatting of a Google Sheet look new:

  1. Select the cells that you want to change.

  2. Then go to the Format tab at the top

  3. Click on Clear Formatting.

What format should I use when wrapping a text in a cell so I can read it thoroughly?

The Text Wrapping option allows you to wrap your data in a cell so you can view it completely.

When can I use the Paint Format to change my cell style?

The purpose of the Paint format is to copy a cell's formatting to another selected partition.

Related Articles:

Google Sheets Highlight Duplicates: Everything You Need to Know

How to Make a Graph In Google Sheets

How to Remove Duplicates in Google Sheets Without Shifting Cells


Want to Make Excel Work for You? Try out 5 Amazing Excel Templates & 5 Unique Lessons

We hate SPAM. We will never sell your information, for any reason.