Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

Google Sheets Formatting


Formatting

Google Sheets has many ways to format and style a spreadsheet.

Why format and style your spreadsheet?

  • Make it easier to read and understand
  • Make it more presentable

Styling is about changing the looks of cells, such as changing colors, font, font sizes, borders, number formats, and so on.

The most used styling functions are:

There are two ways to access the styling commands in Google Sheets:

  1. The Ribbon
  2. Format menu

Note: Formatting can be applied to any range.

Read more about the Ribbon and the menu in the Google Sheets overview chapter.


Styling Commands in Ribbon

The Ribbon provides many formatting options such text and border coloring.



Styling Commands in Format menu

You can also select any cell or a range of cells and then click on the Format menu in the menu bar:


Example

In this example, different formatting options have been applied to range A1:B3.


Chapter summary

Formatting is used to make spreadsheets more readable. There are many ways to add styles. The most common ones are; Color, Font, Number format and Gridlines.