-
GS Tutorial
- GS HOME
- GS Introduction
- GS Get Started
- GS Overview
- GS Syntax
- GS Ranges
- GS Fill
- GS Move Cells
- GS Add Cells
- GS Delete Cells
- GS Undo Redo
- GS Formulas
- GS Relative Reference
- GS Absolute Reference
- GS Arithmetic Operators
- GS Parentheses
- GS Functions
- GS Location Settings
- GS Formatting
- GS Format Painter
- GS Format Colors
- GS Format Fonts
- GS Format Borders
- GS Format Numbers
- GS Format Grids
- GS Format Clear
- GS Sort
- GS Sort Sheet
- GS Sort By Range
- GS Sort Range
- GS Conditional Formatting
- GS Single Color Formatting
- GS Color Scale Formatting
GS Functions
Google Sheets Formatting
Google Sheets has many ways to format and style a spreadsheet
Formatting
Google Sheets has many ways to format and style a spreadsheet.
Why format and style your spreadsheet?
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:
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.