Sharing, printing and protecting
Print on one page, add comments, and protect cells and formulas.
Lessons
In the order the Roadmap teaches them.
In the full course. Beginner · 8 min
Print a sheet on one page
Make a wide or long sheet print on one page, after checking the pages in the print preview.
See the lessonIn the full course. Beginner · 8 min
Repeat header rows on every page
Print a long list with its column names at the top of every page.
See the lessonIn the full course. Beginner · 8 min
Set a print area
Choose which cells of a sheet print, so a printout shows only the part people need.
See the lessonIn the full course. Confident · 8 min
Comments and notes
Add a comment to ask a question and a note to label a cell, and choose the right one.
See the lessonIn the full course. Confident · 9 min
Protect cells from editing
Protect a sheet so people can fill in the cells you choose and nothing else.
See the lessonIn the full course. Advanced · 9 min
Hide formulas from others
Share a file so people see your results but not your formulas, and know how far that can be trusted.
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.