Google Sheets – Starter Tips

7 May 2018
Lara Kirk

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.


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


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.


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.


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.


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.

Recent Posts

Here’s What
Our Clients Say

PR Industrya


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

Download your skills checklist to see how you score...


Choose Industry:

Which Skills Checklist?


Sign Up Now
To Get The Latest Updates


Pop in your details below and we'll send you the PLD Checklist 📧

First time applying for MoE Funded PLD?

Get the Latest Blog Posts, New Tips And Tricks


NSW DoE Leadership Webinars


NSW DoE Leadership Webinars


Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: