The Edvocate

Top Menu

Main Menu

  • Start Here
    • Our Brands
    • Governance
      • Lynch Educational Consulting
      • Dr. Lynch’s Personal Website
      • Careers
    • Write For Us
    • Books
    • The Tech Edvocate Product Guide
    • Contact Us
    • The Edvocate Podcast
    • Edupedia
    • Terms and Conditions
    • Privacy Policy
  • PreK-12
    • Assessment
    • Assistive Technology
    • Child Development
    • Classroom Management
    • Early Childhood
    • EdTech & Innovation
    • Education Leadership
    • Equity
    • First Year Teachers
    • Gifted and Talented Education
    • Parental Involvement
    • Policy & Reform
    • Special Education
    • Teachers
  • Higher Ed
    • Best Colleges and Universities
    • Best College and University Programs
    • Diversity
    • HBCU’s
    • Higher Education
    • Higher Education EdTech
    • International Education
  • Advertise
  • The Tech Edvocate Awards
    • The Awards Process
    • Finalists and Winners of The 2022 Tech Edvocate Awards
      • Finalists and Winners of The 2021 Tech Edvocate Awards
      • Finalists and Winners of The 2020 Tech Edvocate Awards
      • Finalists and Winners of The 2019 Tech Edvocate Awards
      • Finalists and Winners of The 2018 Tech Edvocate Awards
      • Finalists and Winners of The 2017 Tech Edvocate Awards
    • Award Seals
  • Apps
    • GPA Calculator for College
    • GPA Calculator for High School
    • Cumulative GPA Calculator
    • Grade Calculator
    • Weighted Grade Calculator
    • Final Grade Calculator
  • The Tech Edvocate
  • Pedagogue
  • P-20 Ed Careers

logo

The Edvocate

  • Start Here
    • Our Brands
    • Governance
      • Lynch Educational Consulting
      • Dr. Lynch’s Personal Website
        • My Speaking Page
      • Careers
    • Write For Us
    • Books
    • The Tech Edvocate Product Guide
    • Contact Us
    • The Edvocate Podcast
    • Edupedia
    • Terms and Conditions
    • Privacy Policy
  • PreK-12
    • Assessment
    • Assistive Technology
    • Child Development
    • Classroom Management
    • Early Childhood
    • EdTech & Innovation
    • Education Leadership
    • Equity
    • First Year Teachers
    • Gifted and Talented Education
    • Parental Involvement
    • Policy & Reform
    • Special Education
    • Teachers
  • Higher Ed
    • Best Colleges and Universities
    • Best College and University Programs
    • Diversity
    • HBCU’s
    • Higher Education
    • Higher Education EdTech
    • International Education
  • Advertise
  • The Tech Edvocate Awards
    • The Awards Process
    • Finalists and Winners of The 2022 Tech Edvocate Awards
      • Finalists and Winners of The 2021 Tech Edvocate Awards
      • Finalists and Winners of The 2020 Tech Edvocate Awards
      • Finalists and Winners of The 2019 Tech Edvocate Awards
      • Finalists and Winners of The 2018 Tech Edvocate Awards
      • Finalists and Winners of The 2017 Tech Edvocate Awards
    • Award Seals
  • Apps
    • GPA Calculator for College
    • GPA Calculator for High School
    • Cumulative GPA Calculator
    • Grade Calculator
    • Weighted Grade Calculator
    • Final Grade Calculator
  • The Tech Edvocate
  • Pedagogue
  • P-20 Ed Careers
  • What is a Course?

  • Universal Screening vs. Diagnostic Assessment

  • Developing Your First Edtech MVP

  • The Lean Startup Methodology Edtech Startups Must Adopt

  • How to Avoid Poor Tech Training Practices

  • Say Goodbye to the Digital Revolution

  • What Works for Tracking Learner Progress in ELearning

  • ELearning Elements

  • 5 Ways Kids Use Working Memory During the Learning Process

  • Effective ELearning Practices

Early Childhood & K-12 EdTechGoogle ClassroomHigher Education EdTech
Home›Early Childhood & K-12 EdTech›8 Basic Google Sheets Tips Every Teacher Should Know About

8 Basic Google Sheets Tips Every Teacher Should Know About

By Matthew Lynch
May 24, 2018
4694
0
Spread the love

Google provides a lot of useful programs for teachers, but not everyone understands just how to use them. There are a lot of hidden features available for teachers, particularly when it comes to Google Sheets. Understanding how to use these features and apply them in the classroom is essential to help you create better documents in less time.

To get you started, here are eight of the most basic Google Sheets tips that every teacher should know about.

Add a Line Break

While editing a cell, you can insert a line break to help organize your text better. All you have to do is make sure that your cursor is in the cell, ready to type. Press Ctrl+Enter to move to the next line without changing cells.

Merge Cells

Do you need to combine cells in the spreadsheet? You can merge cells both vertically and horizontally. Simply highlight all of the cells you plan to combine and then click merge on the toolbar. There should be a drop-down menu that will give you additional options.

Freeze or Unfreeze Columns and Rows

If you want to see a certain row or column while you scroll, you need to freeze it in place. Highlight the row or column that you would like to freeze. Click “view” and then “freeze or unfreeze.” It might also give you an option to select how many rows or columns you want to freeze in place.

Add a Chart

You can customize your own chart or graph to add to the document with the data you added on the spreadsheet. Highlight all of the data you want to be included in your chart. Under the “insert” tab, you will find a separate option for “chart.” Teachers can choose the type of chart they want under the recommendations tab. Edit the display and the chart itself under the customization chart before you click “insert.”

Use a Formula

Do you want to avoid doing all of the math with your data? You can enter a formula to keep you from pulling out the calculator. In a cell, you can type in the equal sign with the function you want to use. This should prompt a separate help box to pop up that gives you the list of available functions, the wording for each function, and an example of how to use it.

Wrap Text 

If you want to wrap the text in your spreadsheet, select the cell. You can click on the format tab to bring up a list of options. Select text wrapping and then click “wrap.” Follow the same steps to turn it off but select a different final option. 

Protect a Sheet or Range 

Are you afraid someone will edit your spreadsheet? Protect it with this nifty tip. Open up your spreadsheet and head to the data tab. You should see an option for protected sheets and ranges. A separate box will appear after you click here, asking if you want to add a sheet or range to your protection. Select the appropriate options and finish by following the prompts to set permissions or change permissions. Click save or done when you are finished. 

Add a Custom Date or Time 

Start by highlighting the data you want to convert to a specific date or time formula. Then, you will need to head to the format tab and click on “number.” There will be another option for “more formats” and then “more date and time formats.” Find the option that you want or set your own custom date and time format into the search box. Click apply to make it stick.

Previous Article

My Vision for the Future of Personalized ...

Next Article

Which Country Is Leading the Edtech Movement?

Matthew Lynch

Related articles More from author

  • Digital & Mobile TechnologyDigital LeadershipEarly Childhood & K-12 EdTechFeatured

    How Teachers Can Model Digital Leadership For Their Students

    December 10, 2018
    By Matthew Lynch
  • Higher EducationHigher Education EdTech

    What Colleges Should Do to Get Ready for Generation Alpha

    January 19, 2018
    By Matthew Lynch
  • Early Childhood & K-12 EdTech

    Students Should be Taught to be Digital Leaders Instead of Digital Citizens

    January 8, 2018
    By Matthew Lynch
  • Higher EducationHigher Education EdTech

    How Exchange Students Are China’s Trojan Horse

    January 10, 2018
    By Matthew Lynch
  • Higher Education EdTech

    Implementing Blended Learning in Higher Education

    April 7, 2017
    By Matthew Lynch
  • Early ChildhoodEarly Childhood & K-12 EdTechEducation LeadershipHigher EducationHigher Education EdTech

    10 Essential Skills for the Education Leader of Tomorrow

    November 11, 2017
    By Matthew Lynch

Leave a reply Cancel reply

  • Artificial IntelligenceDigital & Mobile Technology

    Careers in Artificial Intelligence

  • Artificial IntelligenceEdTech & Innovation

    Customized Educational Programs Through AI

  • Artificial Intelligence

    Artificial Intelligence Apps, Tools, and Resources That We Love

Search

Registration and Login

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Newsletter

Signup for The Edvocate Newsletter and have the latest in P-20 education news and opinion delivered to your email address!

Subscribe to The Edvocate Podcast

Apple PodcastsGoogle PodcastsAndroidby EmailRSS
  • Recent

  • Popular

  • Comments

  • What is a Course?

    By Matthew Lynch
    May 16, 2022
  • Universal Screening vs. Diagnostic Assessment

    By Matthew Lynch
    May 16, 2022
  • Developing Your First Edtech MVP

    By Matthew Lynch
    May 15, 2022
  • The Lean Startup Methodology Edtech Startups Must Adopt

    By Matthew Lynch
    May 15, 2022
  • How to Avoid Poor Tech Training Practices

    By Matthew Lynch
    May 14, 2022
  • 18 Reasons the U.S. Education System is Failing

    By Matthew Lynch
    April 3, 2017
  • The Top 5 Unexpected Benefits of Early Childhood Education

    By Matthew Lynch
    February 29, 2016
  • 7 Benefits of STEM Education

    By Matthew Lynch
    January 12, 2019
  • What is Culturally Responsive Pedagogy?

    By Matthew Lynch
    April 21, 2016
  • pass or fail

    Black Boys in Crisis: Why Aren’t They Reading?

    By Matthew Lynch
    January 16, 2017
  • Stefanie B.C
    on
    May 12, 2022

    Pass or Fail: Standardized Testing and Education Problems in the U.S.

    I am the mother ...
  • 4 Strategies AI Will Be a Terrific Teaching Assistant – Ssc Wanfa
    on
    May 10, 2022

    Seven Things Assessment-Literate Educators Need to Do When Creating Quality Assessments

    […] is a further ...
  • 4 Techniques AI Will Be a Wonderful Instructing Assistant – iWerd
    on
    May 10, 2022

    Seven Things Assessment-Literate Educators Need to Do When Creating Quality Assessments

    […] is a different ...
  • Vukasin
    on
    May 6, 2022

    18 Reasons the U.S. Education System is Failing

    That would just anger ...
  • Vukasin
    on
    May 6, 2022

    18 Reasons the U.S. Education System is Failing

    I'm more than happy ...

Ask an Expert

  • Ask An Expert

    How Dumbed Down Education Is Creating a National Security Crisis

    Spread the loveFor the past few decades, our country’s educational system has seen both struggle and tremendous change. With the various ailments plaguing our educational system, education reforms have attempted ...
  • Ask An Expert

    21 Inspirational Quotes That Nelson Mandela Made About Education

    Spread the loveWe all have our heroes. Those human beings that seem larger than life and almost achieve Godlike status. One of my heroes is the late-great Nelson Mandela, who ...
  • Ask An ExpertAssistive TechnologyCareer ReadinessChild Development TechClassroom ManagementDigital & Mobile TechnologyDigital LeadershipDisabilitiesDiversityEarly ChildhoodEarly Childhood & K-12 EdTechEdTech & InnovationEducation LeadershipElementary EducationElementary SchoolEquityFirst Year TeachersFreshHigh SchoolK-12Middle SchoolModern ParentingParent & Family TechParental InvolvementParentingPersonalized LearningPodcastPolicy & ReformPreK-12Special EducationSTEMTeacher EducationTeachers

    The Edvocate Podcast, Episode 7: How Digital Age Teachers Can Win Over Parents

    Spread the loveEducation is a collaborative process, as it takes many stakeholders working in unison to help students succeed academically. One of the most integral parts of this collaborative team ...
  • Ask An ExpertAssessmentAssistive TechnologyBlack Boys in CrisisChild Development TechClassroom ManagementDigital & Mobile TechnologyDigital LeadershipDisabilitiesEarly ChildhoodEarly Childhood & K-12 EdTechEdTech & InnovationEdTech Policy & ReformEducation LeadershipElementary EducationElementary SchoolEquityFeaturedFirst Year TeachersFreshGamificationGifted and Talented EducationHBCU'sHigh SchoolHigher EducationK-12Online Learning & eLearningOpEducationPersonalized LearningPodcastPolicy & ReformRetention & Social Promotion SeriesSpecial EducationSTEMTeacher EducationTeachersTesting

    The Edvocate Podcast, Episode 6: 8 Ways That Digital Age Teachers Avoid Burning Out

    Spread the loveBeing a teacher is a tough job. So much so, many new teachers end up leaving the field within their first three years. To ensure that the next ...
  • Ask An ExpertAssessmentAssistive TechnologyBlack Boys in CrisisBullyingChild DevelopmentChild Development TechClassroom ManagementCurrent Ed NewsDigital LeadershipEarly ChildhoodEarly Childhood & K-12 EdTechEdTech & InnovationEdTech Policy & ReformEdTech Startups & BusinessesEducation LeadershipEquityFeaturedFirst Year TeachersFreshGamificationGifted and Talented EducationHBCU'sHigh SchoolHigher EducationHigher Education EdTechK-12Matthew LynchModern ParentingOnline Learning & eLearningOpEducationPersonalized LearningPodcastPolicy & ReformRetention & Social Promotion SeriesSpecial EducationSTEMTeacher EducationTeachersTestingYear-Round Schooling

    The Edvocate Podcast, Episode 5: The Archetype of a Great Teacher

    Spread the loveOne of the questions that I am frequently asked is, what does a good teacher look like? I respond by mentioning my 10th-grade Biology teacher, Mrs. Minor, and ...

International Education

  • International Education

    How International Baccalaureate (IB) Programs Work

    Spread the loveThe International Baccalaureate Program is a very intensive pre-college program in which when students get involved, they get college credit. Unlike most other learning initiatives, this program deeply ...
  • International Education

    Globalization: Everything You Need to Know

    Spread the loveGlobalization is the growing interconnectedness of countries around the world. It involves increasing communication and various forms of interaction between people of different nations, ethnicities and cultures. There ...
  • AssessmentEducation LeadershipHigher EducationInternational EducationProfessional DevelopmentTeachers

    So You Want to Attend Graduate School: The 411 on Grad School Admissions Tests

    Spread the loveApplying for admission to professional and graduate schools is no less competitive than college/undergraduate admissions. If you’re planning to pursue a degree in business, law, medicine, or graduate ...
  • Higher EducationInternational Education

    What Extracurricular Activities Impress Colleges the Most?

    Spread the loveWhen you apply to schools that offer holistic admissions or apply to a college using the Common Application, you will have to describe your participation in extracurricular activities. ...
  • Higher EducationInternational Education

    Tips for Working on a College Group Project

    Spread the loveIt can be a great experience to work together and do a group project in college. But it can also be a nightmare if there is no cooperation ...

Early Childhood Education

  • Early ChildhoodLanguage Education

    Long Vowels: Everything You Need to Know

    Spread the loveLong vowels are special vowel types that sound exactly like the letters which comprise them. Long vowels are typically taught after short vowels because while it seems less ...
  • Early Childhood

    What is a Digraph (vowel)?

    Spread the loveA vowel digraph refers to the distinctive perception of one sound when two vowels are placed together in one word. e.g., ow, oa, ie, ea. For learners, vowel ...
  • Early Childhood

    What is a Digraph (consonant)?

    Spread the loveA consonant digraph refers to the distinctive perception of one sound when two consonant letters are placed together in one word, e.g., ch, ng, sh, ph. It’s important ...
  • Early Childhood

    Modifications: Everything You Need to Know

    Spread the loveThis term refers to the adjustments made to what a child is required to learn in school. Some common examples of modifications include reworded questions in easier language, ...
  • Early Childhood

    Wraparound Services/Programs: Everything You Need to Know

    Spread the loveThese are programs that have social measures available for children who are at risk.  Hypothetically, these services are engineered toward developing a strong sense of self and the ...

Gifted and Talented Education

  • Gifted and Talented Education

    Twice-Exceptional: What Does it Mean?

    Spread the loveTo be twice-exceptional is to be exceptionally gifted in some academic aspects while being below average compared to peers in other aspects. As a matter of fact, such ...
  • Gifted and Talented Education

    A Guide to Talent Search Programs

    Spread the loveThe Talent Search Initiative has as its aim; the identification of high-performing students by organizing specific tests. Different avenues are then provided for these students to channel their ...
  • Gifted and Talented EducationK-12

    Homogeneous Grouping: What You Need to Know

    Spread the loveThis term refers to the grouping of students by mental capability, aptitude, or hobbies. For instance, gifted students are placed in one group, and students with special needs ...
  • Gifted and Talented Education

    Cluster Grouping: What You Need to Know

    Spread the loveThis term describes a manner of classifying gifted students to place them in properly segmented classrooms. For example, about five to seven extremely bright pupils with comparable skill ...
  • Gifted and Talented EducationHigher Education

    Merit Scholarships: Everything Your Need to Know

    Spread the loveThese are monetary gifts awarded by institutions to superbly gifted students, who have set themselves apart by their exceptional performance in schoolwork, regardless of whether they require the ...

Black Boys in Crisis Series

  • Black Boys in Crisis

    The Importance of Mentoring Young African-American Males

    Spread the loveTeachers need to realize that at home, in their neighborhoods, and in school, many students face difficulties that can interfere with learning. Compared to their middle-class counterparts, it ...
  • Black Boys in CrisisDiversityEquity

    7 Ways That Black Students are Discriminated Against in U.S K-12 Schools

    Spread the loveAfrican Africans have a long history of being mistreated in the United States, starting with slavery. It should come as no surprise that their children face the same ...
  • Ask An ExpertAssessmentAssistive TechnologyBlack Boys in CrisisChild Development TechClassroom ManagementDigital & Mobile TechnologyDigital LeadershipDisabilitiesEarly ChildhoodEarly Childhood & K-12 EdTechEdTech & InnovationEdTech Policy & ReformEducation LeadershipElementary EducationElementary SchoolEquityFeaturedFirst Year TeachersFreshGamificationGifted and Talented EducationHBCU'sHigh SchoolHigher EducationK-12Online Learning & eLearningOpEducationPersonalized LearningPodcastPolicy & ReformRetention & Social Promotion SeriesSpecial EducationSTEMTeacher EducationTeachersTesting

    The Edvocate Podcast, Episode 6: 8 Ways That Digital Age Teachers Avoid Burning Out

    Spread the loveBeing a teacher is a tough job. So much so, many new teachers end up leaving the field within their first three years. To ensure that the next ...
  • Ask An ExpertAssessmentAssistive TechnologyBlack Boys in CrisisBullyingChild DevelopmentChild Development TechClassroom ManagementCurrent Ed NewsDigital LeadershipEarly ChildhoodEarly Childhood & K-12 EdTechEdTech & InnovationEdTech Policy & ReformEdTech Startups & BusinessesEducation LeadershipEquityFeaturedFirst Year TeachersFreshGamificationGifted and Talented EducationHBCU'sHigh SchoolHigher EducationHigher Education EdTechK-12Matthew LynchModern ParentingOnline Learning & eLearningOpEducationPersonalized LearningPodcastPolicy & ReformRetention & Social Promotion SeriesSpecial EducationSTEMTeacher EducationTeachersTestingYear-Round Schooling

    The Edvocate Podcast, Episode 5: The Archetype of a Great Teacher

    Spread the loveOne of the questions that I am frequently asked is, what does a good teacher look like? I respond by mentioning my 10th-grade Biology teacher, Mrs. Minor, and ...
  • Ask An ExpertAssistive TechnologyBlack Boys in CrisisBullyingChild DevelopmentChild Development TechClassroom ManagementDisabilitiesDiversityEarly ChildhoodEarly Childhood & K-12 EdTechEdTech & InnovationEdTech Policy & ReformEducation LeadershipElementary EducationElementary SchoolEquityFeaturedFirst Year TeachersFreshGifted and Talented EducationHigh SchoolHigher EducationHigher Education EdTechK-12Middle SchoolModern ParentingOnline Learning & eLearningParent & Family TechParentingPersonalized LearningPodcastPolicy & ReformSecondary EducationSTEMTeacher EducationTeachersTesting

    The Edvocate Podcast, Episode 4: How to Create a Culturally Responsive Classroom

    Spread the loveBuilding a culturally responsive classroom is hard. To help you along your journey, here is your guide to exploring and respecting the cultural backgrounds of your students while ...

RSS Matthew on Education Week

  • Au Revoir from Education Futures November 20, 2018 Matthew Lynch
  • 6 Steps to Data-Driven Literacy Instruction October 17, 2018 Matthew Lynch
  • Four Keys to a Modern IT Approach in K-12 Schools October 2, 2018 Matthew Lynch
  • What's the Difference Between Burnout and Demoralization, and What Can Teachers Do About It? September 27, 2018 Matthew Lynch
  • Revisiting Using Edtech for Bullying and Suicide Prevention September 10, 2018 Matthew Lynch

About Us

The Edvocate was created in 2014 to argue for shifts in education policy and organization in order to enhance the quality of education and the opportunities for learning afforded to P-20 students in America. What we envisage may not be the most straightforward or the most conventional ideas. We call for a relatively radical and certainly quite comprehensive reorganization of America’s P-20 system.

That reorganization, though, and the underlying effort, will have much to do with reviving the American education system, and reviving a national love of learning.  The Edvocate plans to be one of key architects of this revival, as it continues to advocate for education reform, equity, and innovation.

Newsletter

Signup for The Edvocate Newsletter and have the latest in P-20 education news and opinion delivered to your email address!

Contact

The Edvocate
5322 Markel Road, Suite 104
Richmond, VA 23230
(601) 630-5238
[email protected]

Follow us

Copyright (c) 2022 Matthew Lynch. All rights reserved.