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
ChannelHello, Teacher LadyDescription 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]
⬇ 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.
- Channel
- Hello, Teacher Lady
- Category
- Education
- Duration
- 16:48
- Published
- November 5, 2019
- Views
- 128,225
- Likes
- 1,626
Share
This tutorial in other languages
- FRComment utiliser les outils de mise en forme de Google Sheets | Guide de l'enseignant # 1 | Didacticiel interactif
- ESCómo utilizar las herramientas de formato de cálculo de Google | Guía del Maestro: # 1 | Tutorial interactivo
- PTComo usar as ferramentas de formatação de planilhas do Google | Guia de um professor # 1 | INTERACTIVE TUTORIAL
- ITCome utilizzare gli strumenti di formattazione in Google Fogli | Una guida per insegnanti # 1 | Tutorial interattivo
- DEWie die Formatwerkzeuge in Google Tabellen verwenden | Ein Lehrer-Begleitheft # 1 | Online-Kursus
- NLHoe de opmaakhulpmiddelen in Google Sheets | Een docentenhandleiding # 1 | Interactieve handleiding
- RUКак использовать Форматирование в Google Таблицах | Руководство для учителя # 1 | Интерактивное учебное пособие
- PLJak korzystać z formatowania TOOLS w Arkusze Google | Poradnik dla nauczyciela nr 1 | Interaktywny samouczek
- JAGoogleシートの書式ツールの使用方法| Aティーチャーズ・ガイド#1 | INTERACTIVE TUTORIAL
- ARكيفية استخدام أدوات التنسيق في صفائح جوجل | دليل المعلم # 1 | البرنامج التعليمي التفاعلي
- HIकैसे Google पत्रक में प्रारूपण उपकरण का उपयोग करने के | एक शिक्षक की मार्गदर्शिका # 1 | इंटरैक्टिव ट्यूटोरियल
- IDCara Menggunakan FORMAT ALAT di Google Sheets | Sebuah Guru Panduan # 1 | INTERAKTIF TUTORIAL