How to Use the FORMATTING TOOLS in Google Sheets | A Teacher's Guide #1 | INTERACTIVE TUTORIAL
HTML-код
- Опубликовано: 14 июл 2024
- 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/...
⬇ 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: www.teacherspayteachers.com/P...
▪ Student Growth Data Tracker: www.teacherspayteachers.com/P...
⬇ LET'S CONNECT ⬇
WEBSITE: www.helloteacherlady.com
INSTAGRAM: / helloteacher. .
TWITTER: / shanateaches
EMAIL: shana@helloteacherlady.com
After 35 years in a Middle School classroom I know that teaching is a gift. Many brilliant people just cannot get information across to others in a form that is easily understandable. You have presented this in an excellent manner and left no doubt as to how to do the functions available in the program. Wonderful job. Looking forward to your other videos. Now I have to go type up my notes.
Wow, thank you so much!
Easy to follow along with. You've made something seemingly difficult fun and inspiring. I'll make sure to pay it forward. Thank you. 🙏
Thank you, Ms. Teacher Lady!
(Now I have to change my favorite teacher answer in all my security questions.)
This is so amazing, I'm only quarter way through and my Excel sheet is already looking so amazing, so easy to follow, thank you for sharing!
Fantastic, Teacher Lady! Thank you!
Thank you so much !! I really needed this tutorial.
this is amazing - you are such a great help!! Thanks again.
A great, comprehensive video, thank you!
Wow! Lots of good tips here! Looking forward to viewing the next one!
Awesome, thank you!
The GOT names! Nice touch!!
You make excellent vids! Lot's of great & important tips dispersed in an efficient manner. NO FLUFF!
Thanks a lot! Appreciate it. :)
You explain very well. I learned a lot with this tutorial. Tks.
Thank you so much for an excellent presentation. It helped me a lot for an assignment I needed to complete and as I'm not too familiar with Google Sheets - its was very much appreciated. You also have a wonderful way of presenting
This was very helpful. Thank you!
You are a great teacher. Thank you.
Thanks! Very helpful.
Learned a ton from this. Thank you!
So clear! Thank you!
This is the first video I watched that felt like it made good and complete sense. Leave it to a teacher! :) Thank you!
So happy to hear that, thank you!
me too!
I've been reluctant to try google sheets because I really didn't know where to start. Your videos are exactly what I've been looking for as I prepare for the next school year. Thank you for sharing all of these useful tips!
Thank you for the kind words! So glad the video was helpful.
LOVED YOUR GREAT VIDEO AND I THANK YOU VERY MUCH FOR THIS EFFORT. YOU ARE A GREAT TEACHER. WISH YOU THE VERY BEST.
You're very welcome!
absolutely loved the content. keep up the good job.
Take love❤
Super easy to follow. You are so helpful. Thank you for putting in the time. I have subscribed to see all your videos to get better at Google.
Awesome! Thank you!
A Million and one thank yous!
So helpful! Thank you!
Awesome video! Thanks for posting. This is the first one that I found that clearly explains how to merge cels.
Glad it was helpful!
Very helpful video on formatting with Google Sheets. I learned several new tricks. Thank you for sharing your knowledge.
Yay, happy to hear!
so helpful! Thank you
Great tutorial.....thank you!
Thank you very much for this video.
Thank you very much! This video is helping me a lot :)
Very very helpful!
very informative and I GOT your sense of humor cheers to you
Haha, love it. Thanks!
Thank you 🙏🏻
I am so glad I found you! I am a teacher and I want to make life easier and organized with data! This helped so much!
So glad it was helpful!
Thanks so much for doing this!! It is so helpful. Would love to see more videos for google in the classroom. Do you do your gradebook in google too?
This is awesome, so many helpful tips and easy to follow along!! What font did you use for "October" in your monthly calendar, I love it! Do you design fonts as well? Thanks again!
Thanks for this tip 3:37!
thanks was very helpful
Thanks a lot...
very helpful and clear to understand. just learned about conditional formatting - if students enter correct answer in cell - the cell can turn green to let them know answer is correct. My question is how can I protect this formatting so that kids can't tinker with it? Can you show us how to do that?? I'll look for that video.
Great video...very helpful. Is there anyway to change one individual cell width, not merging, but just that one cell?
Instead of resizing the columns multiple times, I'd just select them all and double click the spot used to resize them. This will make each column be resized to its optimal size :)
Could you help me? I would like to input a time in minutes and seconds, and have it display in just seconds for printing. For example if I type in 0:10:06 or 10.6 (as in 10min 6seconds) I want 606 to be displayed in that cell. If yes, could you also do this with hours?
In Excel ctrl+ arrows allow us to jump to the last value of the column or row. What's the equivalent of that in google sheet?
I can’t find the third video on Google Sheets that you mentioned in the 2nd one! Is it available?
I learned how to make a crossword puzzle in sheets for my students' distance learning. I am having trouble editing the notes attached to the across/down clues. I changed the numbers in each note but when I click on the print option to view it, the old numbers are still showing. Do you know how I can change these? Thanks for your help.
Hi Mary,
I'm not sure what you mean by "notes" -- Can you elaborate?
Been trying to print a file ,,, I have 1final colmn that prints, by itself, on a SEPARATE pg. Are there Margin settings I can adjust, [There is space available on my Landscape sheet.].
Hello There!!!
Q: Microsoft Excel Made It So User Friendly To Locate, View And Delte Duplicates With Highlights. I Know Google Sheets Has A "Unique" Way Of Doing Such But It's NOT User Friendly At All. Is There An Easier Way To See, Manage and Have Duplicates Highted To Work WIth Using Sheets? My Job Does Not Use Microsoft Any Longer, We've Transitioned Strictly To The Use Of Google EVERYTHING, Can You Please Help?
Baric Dondarian is bringing blackstrap rum from home. Keep him in the front of the bus.
😂😂😂
Would you please explain how: to place the file icon on DESKTOP. Thanks!
When you sorted by last name, all the data went with it! Mine sorts the name column but leaves the data of the previous student list so it's all mismatched. How do I fix this?
Hey, you might want to freeze the last name column before you sort it. That way the rest of the data stays aligned with that column.
Thank you for the video. Do you have a video that explains how to set up a Google spreadsheet for 8.5" x 11". I have one and it scrolls very long. When I try to print, (hitting fit to page) it ends up cutting rows off in the middle. Hope that makes sense. Thank you!!
Hi Cindy,
Fit to Page, Width or Height usually does the trick. Sometimes you have to play around with the settings a bit.
I sense you are well knowlegible to advise on this predictiment. My 'sheet contains 8 colmns., however, I only want to display 5, on a Chart.
Is there some Formatting/Shortcut option, I could use to achieve this? Thanks!
Just saw your application of the CTRL key. Prob. solved!
I think filter can work
Do you have a shareable growth tracker?
Thanks! My google sheets game about to be way prettier!
How did you get your student growth data formated like that
LOL I noticed that all your students names are names of characters from Game Of Thrones
On your Growth Data Chart, it looks like you have an image inserted into your cells for your title. If so, what size image did you build so it didn't get wonky? Also, what font is that?! I NEEEEED it in my life.
If you insert the image into the actual cell, it automatically resizes the image based on the width/height of the cell. I believe the font is from A Perfect Blend -- one of the ones with coffee in the name (can't remember exactly).
what if one student had 3 lunch choices or say this column was subjects and each child had 5 or more different subjects under a 'class' column. How do you sort and filter each subject
How do I take a freeze off column A?
Great tutoials on Google Sheets, thanks for posting them. But your playlist of them has #1 & #2 REVERSED! (I thought I was the only one who makes silly mistakes like this and doesn't notice.)
Hello Teacher Lady! I am using Google Sheets for my small Business. When I make an invoice and download it into a PDF form the font is so small.. how do I fix this. BTW I put the font as high as 18 so it can be a little visible. THANKS!!!!!!!!
Make sure you have Fit to Page or Fit to Width/Height selected. Try each of them to see which one is best for your specific document.
How to high light cell which is greter than next cell
Game of thrones fan
This is brilliant, thank you! BUT the faint background music is driving me nuts! Can you get rid of it somehow? Thank you
Cool tips, but we're just supposed to believe that all those opposing factions from Game of Thrones would allow themselves to be organized in a single spreadsheet? I'm not buying it. Daenerys Targaryen doesn't do 'permission slips'.
😂😂😂
You know how to teach
Good presentation, but please slow down.
Try slowing down the video in settings, I've used it a lot on fast videos so I can keep up.
Thank you, I've so many sheets that will be that bit better now. Khal Drogo wouldn't fit in a small t-shirt by the way.lol
Hahaha, best comment.
text