• icon 1 (02) 8005 7066
  • icon 2 03 669 2973
  • icon 3 (714) 987 9833

Google Sheets – Starter Tips

Google Sheets is a great tool for classroom teachers. It can help you increase your efficiency and organisation. If you’ve never used spreadsheets before they can be a little intimidating, but once you get started I’m sure you’ll realise how powerful Google Sheets really is.

Google Sheets is a great tool for classroom teachers. Click To Tweet

Many of the things you’ll want to do in Google Sheets are really straightforward and are done in a similar way to Docs or Slides. However, there are a few things that operate a little differently and can be really frustrating when you first start using this great tool.

Here’s five tips that I wish I’d known when I first started out with Sheets.

PARAGRAPHS IN CELLS

When you have been typing in a cell in Google Sheets and you hit enter, your cursor will move to the next cell. If you want to create paragraphs within a cell you need to hold down command + enter (MAC) or ctrl + enter (PC).

HYPERLINKS

You can create hyperlinks within a sheet in the same way you do in a doc. However, you can’t hyperlink from a multi-paragraph cell. If you really want it to look like multi-paragraphs create your text in seperate cells, link the ones you want, then make the borders between them white.

TEXT WRAPPING

The default setting is to have the text stay within the cell, not changing the cell size even when there is more text than can be displayed in the box. Select the entire sheet (by clicking the box above the columns and beside the rows) then click on the ‘Text Wrapping’ menu and select the one with the bendy arrow. Your rows will now get longer to fit your text.

DROP DOWN BOXES

These are great when you want to categorise things or only have a few options. Click in the cell you would like to have the drop down menu, click on the ‘Data’ menu, choose Data validation, change ‘List from a range’ to ‘List of items’ and add your options. You can share this drop down with all cells in the range by dragging the little square at the bottom of the cell (when you’ve selected it) down over the other cells you’d like to apply this to.

FREEZE ROWS AND COLUMNS

This means that wherever you go on the sheet, or however you sort the sheet, you’ll still be able to see the selected rows and columns. Click in the last column or row that you would like to freeze, go to ‘View’, ‘Freeze’ and select ‘Up to current row’.

5 Google Sheets quick tips to ease your pain! Click To Tweet

Check out this blog post to give you some great ideas for how Google Sheets can make you more organised and efficient.

Head over to our web page or download the Using Technology Better app (iOS or Android) to stay up to date with our blog posts and upcoming events.


Skills Checklist Will Help You Find Out.

Download Free Guide

Latest Blog Posts, New Tips And Tricks

Sign Up Now

Blogger for Teacher Appraisal

Using Google Blogger is not only a great way to reflect on your practice but it also offers an efficient way to align samples of your practice with the Teaching Standards. I have seen many teacher blogs which are done on Google Slides or Sites but the awesome thing about Blogger is that you can label your evidence with the Teaching Standards.

VIEW POST

Customise your Chrome Omnibox for efficient searching

Don’t you just love being able to search Google straight from in the Chrome Omnibox? But did you know you can customise this to make searching in your Inbox, YouTube or Google Drive super easy? Actually, anywhere that you can search can be turned into a search engine right there in your Omnibox, and it’s a fast and easy process to set it up.

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

VIEW FULL CASE STUDY

FREE PDF DOWNLOAD

Are you at a beginner, intermediate, or advanced level? This skills checklist will help you find out.

×

FREE PDF DOWNLOAD

Are you at a beginner, intermediate, or advanced level? This skills checklist will help you find out.

We will only send you awesome stuff!

×