HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Use the FORMATTING TOOLS in Google Sheets | A Teacher's Guide #1 | INTERACTIVE TUTORIAL

128,225 views November 5, 2019 16:48

Watch on YouTube
ChannelHello, Teacher Lady

Description from the creator

This video will walk you through the key formatting tools in Google Sheets, along with a few ESSENTIAL TIPS that will help teachers customize and navigate your spreadsheets more efficiently.

⬇ FOLLOW ALONG ⬇
▪ Download a copy of the mock field trip planning sheet I'm using in the video so you can practice the formatting tools along with me: docs.google.com/spreadsheets/d/10dsK0v3gln3mk73…

⬇ TABLE OF CONTENTS ⬇
▪ 00:13 — Quickly launch a new Google Sheet from Google's Omnibox
▪ 00:30 — Overview of columns, rows, formatting toolbar, and file menu
▪ 01:28 — Highlight entire spreadsheet at once
▪ 01:45 — Change the font, text size, alignment, and other basic formatting
▪ 02:03 — Select and resize multiple cells at once
▪ 03:14 — Wrap text in a cell
▪ 04:40 — Freeze the top row of cells
▪ 05:50 — Split text into two columns
▪ 07:15 — Sort columns alphabetically
▪ 07:43 — Vertically align text in center of cell
▪ 08:24 — Rotate text
▪ 09:14 — Use the alternating colors tool
▪ 11:08 — Insert multiple cells
▪ 12:24 — Merge cells
▪ 13:35 — Add different border styles
▪ 15:35 — Add a margin around spreadsheet data

⬇ RESOURCES SHOWN IN VIDEO ⬇
▪ Monthly Planning Calendar: teacherspayteachers.com/Product/Digital-Monthly…
▪ Student Growth Data Tracker: teacherspayteachers.com/Product/Color-Coded-Stu…

⬇ LET'S CONNECT ⬇
WEBSITE: helloteacherlady.com
INSTAGRAM: instagram.com/helloteacher...
TWITTER: twitter.com/shanateaches
EMAIL: [email protected]

About this tutorial

Hello, Teacher Lady published this 16:48 video tutorial on November 5, 2019. It has been watched 128,225 times on YouTube.

Category
Education
Duration
16:48
Published
November 5, 2019
Views
128,225
Likes
1,626

Share

This tutorial in other languages