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

[@richardstock3669]

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.

[@helloteacherlady]

Wow, thank you so much!

[@eveisbell9207]

This is the first video I watched that felt like it made good and complete sense. Leave it to a teacher! :) Thank you!

[@helloteacherlady]

So happy to hear that, thank you!

[@jenniferprince5735]

me too!

[@mateka7582]

The GOT names! Nice touch!!

[@dhines3804]

Wow! Lots of good tips here! Looking forward to viewing the next one!

[@helloteacherlady]

Awesome, thank you!

[@wahinenuiloa]

Awesome video! Thanks for posting. This is the first one that I found that clearly explains how to merge cels.

[@helloteacherlady]

Glad it was helpful!

[@ontrada]

Fantastic, Teacher Lady! Thank you!

[@Liliane7969]

You explain very well. I learned a lot with this tutorial. Tks.

[@kadiarakingai]

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!

[@EXCELGUPTA]

LOVED YOUR GREAT VIDEO AND I THANK YOU VERY MUCH FOR THIS EFFORT. YOU ARE A GREAT TEACHER. WISH YOU THE VERY BEST.

[@helloteacherlady]

You're very welcome!

[@selap8682]

You are a great teacher. Thank you.

[@paulahamand7963]

Very very helpful!

[@bobobrien7852]

very informative and I GOT your sense of humor cheers to you

[@helloteacherlady]

Haha, love it. Thanks!

[@ambersmith4600]

Very helpful video on formatting with Google Sheets. I learned several new tricks. Thank you for sharing your knowledge.

[@helloteacherlady]

Yay, happy to hear!

[@mai_world]

Thank you, Ms. Teacher Lady! (Now I have to change my favorite teacher answer in all my security questions.)

[@debreale5236]

So helpful! Thank you!

[@melissabruno8975]

Learned a ton from this. Thank you!

[@zebuton]

You make excellent vids! Lot's of great & important tips dispersed in an efficient manner. NO FLUFF!

[@helloteacherlady]

Thanks a lot! Appreciate it. :)

[@amymelchiorre4745]

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!

[@helloteacherlady]

Thank you for the kind words! So glad the video was helpful.

[@Sam-oh2od]

A great, comprehensive video, thank you!

[@louielouie9502]

Easy to follow along with. You've made something seemingly difficult fun and inspiring. I'll make sure to pay it forward. Thank you. 🙏

[@tammypoggimartinelli7184]

Great tutorial.....thank you!

[@ela1288]

Thank you so much !! I really needed this tutorial.

[@hairgirl1970]

Thanks! Very helpful.

[@sherilynneparretti1835]

So clear! Thank you!

[@ginapsmith]

this is amazing - you are such a great help!! Thanks again.

[@reneenealon459]

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.

[@helloteacherlady]

Awesome! Thank you!

[@mordechailewis7201]

Thanks for this tip 3:37!

[@ehsanulkabir2529]

absolutely loved the content. keep up the good job. Take love❤

[@luciarabaleixodasilva4324]

Thank you very much! This video is helping me a lot :)

[@stephanieparkssmith609]

A Million and one thank yous!

[@shanstatedrd7295]

Thank you very much for this video.

[@dwaynewedderburn2971]

This was very helpful. Thank you!

[@atrayah6857]

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

[@argenisaguilar9045]

Thanks a lot...

[@premrajani9030]

thanks was very helpful

[@jessicaborner938]

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?

[@enjee2010]

Thank you 🙏🏻

[@tifaniegary3030]

Do you have a shareable growth tracker?

[@AngelGainesComedianandEducator]

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!

[@helloteacherlady]

So glad it was helpful!

[@jengunderson9283]

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!

[@beef2244]

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?

[@michellehubbard6562]

I can’t find the third video on Google Sheets that you mentioned in the 2nd one! Is it available?

[@vm6011]

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.

[@michelleraftis9943]

Great video...very helpful. Is there anyway to change one individual cell width, not merging, but just that one cell?

[@cindyfornataro8004]

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!!

[@helloteacherlady]

Hi Cindy, Fit to Page, Width or Height usually does the trick. Sometimes you have to play around with the settings a bit.

[@MrMosoani]

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?

[@mollyl8704]

How did you get your student growth data formated like that

[@gripWIN]

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.].

[@gripWIN]

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!

[@gripWIN]

Just saw your application of the CTRL key. Prob. solved!

[@alanp1]

I think filter can work

[@gripWIN]

Would you please explain how: to place the file icon on DESKTOP. Thanks!

[@yaribethquintana9454]

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!!!!!!!!

[@helloteacherlady]

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.

[@marymarkley3674]

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.

[@helloteacherlady]

Hi Mary, I'm not sure what you mean by "notes" -- Can you elaborate?

[@shirleysavage7796]

How do I take a freeze off column A?

[@justbelit]

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

[@arthurazs]

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 :)

[@adammartin7154]

LOL I noticed that all your students names are names of characters from Game Of Thrones

[@waltergerard2]

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?

[@meganchamblee1282]

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.

[@helloteacherlady]

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).

[@dianacansing123]

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?

[@aditisingh9942]

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.

[@amrutapowar706]

How to high light cell which is greter than next cell

[@zacharylemon6444]

Baric Dondarian is bringing blackstrap rum from home. Keep him in the front of the bus.

[@helloteacherlady]

😂😂😂

[@mynametrong5508]

Thanks! My google sheets game about to be way prettier!

[@joostschuur]

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'.

[@helloteacherlady]

😂😂😂

[@Dave.O]

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.)

[@aussiemummy11]

This is brilliant, thank you! BUT the faint background music is driving me nuts! Can you get rid of it somehow? Thank you

[@lanazaakat9466]

Good presentation, but please slow down.

[@fr3heart]

Try slowing down the video in settings, I've used it a lot on fast videos so I can keep up.

[@zaingujjar4854]

Game of thrones fan

[@adrianlasin574]

You know how to teach

[@mrmaceoin2982]

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

[@helloteacherlady]

Hahaha, best comment.

[@hbtuoputhmebaitrrhho1842]

text

[@wendymarcot7274]

so helpful! Thank you