Lesson 3: Customize a Spreadsheet View

Total video watch time - 29:10

LESSON OBJECTIVES

Freeze rows and columns
Enhance the look of a sheet by removing gridlines and applying alternating colors
Easily identify protected cells and cells containinging formulas
Create collapsible and expandable groups of rows and columns
Sort and filter data in your spreadsheet
Create, edit and share filter views
Manipulate data with slicers

Freeze Rows and Columns

Knowing how to freeze rows within a sheet is essential if you plan to sort your data. Additionally, freezing rows and columns helps to lock key data in place while allowing you to view the data that relates to it.

Customize Your View in Sheets

In this tutorial we will take a look at some visual adjustments you can make to a spreadsheet to customize the viewing experience. We will take a look at how to remove gridlines, apply alternating colors, and group rows together so that you can expand and collapse data depending on what you need to see. You'll also learn how to quickly see which cells contain formulas and if there any areas in a sheet that you are restricted from editing.

Sort Your Data

Sorting provides you with a different way to look at your data. Knowing how to sort can assist you with organzing data in your sheet.

Filter Your Data

Filtering provides you with alternate ways to display your data. Knowing how to filter can not only help you to organize data in your sheet, but allow you to easily print selected information and share data with colleagues.

Data Slicer

Data slicers are another way to filter your data. A slicer is a simple button that you add to a sheet that allows you to filter a table or data set. It's an intuitive tool that allows users to manipulate data at a glance. In this video you will learn how to add slicers to your sheet and see how they can be used.

LESSON TASK

IMPORTANT: Before opening the practice task, make sure you are viewing this page with your personal Google Chrome account. This will ensure that a copy of the task is created in your personal Google Account. If you open the task in your school account, some features may be blocked and you will not be able to submit the assignment to Google Classroom.

Click the Practice Task button below, then select the "USE TEMPLATE" button to create an editable copy of the task in your Google Drive.
Follow the steps in the INSTRUCTIONS tab
Click the Solution File button to check your work.
When you have completed the task to the best of your ability, find the "TURN IN" tab in the Practice Task for instructions on how to submit your work.

ADDITIONAL RESOURCES

Slicers in Google Sheets - In this article, learn more about what you can do with Slicers.

Page updated

Google Sites

Report abuse