Formatting
Make numbers, dates and tables readable: currency, percent, borders, wrapping and custom number formats.
Lessons
In the order the Roadmap teaches them.
In the full course. Beginner · 10 min
Number formats: currency, percent, decimals
Show numbers as dollars and percents with the decimal places you want, without changing the numbers underneath.
See the lessonIn the full course. Beginner · 10 min
Show dates the way you want
Show a date as Monday, March 2, 2026, Mon, Mar 2026 or any mix, with built-in and custom date formats.
See the lessonIn the full course. Beginner · 10 min
Fonts, colors and borders
Make a table easy to scan with bold headers, a bigger title, text and fill colors, and borders around or inside it.
See the lessonIn the full course. Beginner · 9 min
Align, wrap and rotate text
Wrap long text inside its cell, line values up left, center, right, top or bottom, and know where to rotate text.
See the lessonIn the full course. Beginner · 9 min
Merge cells (and when not to)
Center a title over a table with a merge, and know why merged cells don't belong inside the table itself.
See the lessonIn the full course. Beginner · 8 min
Copy formatting with the format painter
Copy the look of cells onto others with the format painter, for one row, a bigger range or a whole block at once.
See the lessonIn the full course. Beginner · 9 min
Clear formatting fast
Strip every format from a range in one step, know why Delete doesn't, and put back the date formats you need.
See the lessonIn the full course. Beginner · 10 min
Alternating row colors
Shade every other row of a table with a conditional formatting rule, so the stripes stay right when you sort.
See the lessonIn the full course. Confident · 11 min
Custom number formats
Write your own number format codes to add units, show thousands as K and set decimal places, while the numbers stay numbers.
See the lessonIn the full course. Confident · 12 min
Make a table look professional
Turn a plain table into a clean report with a clear header, the right number formats, borders and every value showing.
See the lessonGet the full course
Every lesson in the Google Sheets course, with new lessons added as they're written.
- All 215 Google Sheets lessons open today, and every new one as it's written.
- The Roadmap, Skills and all seven paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Excel course for US$49.