Teach Yourself VISUALLY Google Workspace

CHAPTER 8

Learning Advanced Google Sheets Features

In this chapter, you learn how to use advanced features in Google Sheets. You start by using the Paste Special command, and then move on to sorting data, filtering data, and applying data validation. After that, you apply protection to ranges and sheets, and learn to automate procedures by creating and running macros.

Using Paste Special and Transposing Data

Sort Your Data

Filter Data in a Sheet

Apply Data Validation to Your Sheets

Protect Ranges in a Sheet

Protect a Sheet

Create a Macro

Run a Macro

Manage Your Macros

Using Paste Special and Transposing Data

Beyond regular pasting, Google ...