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.


UTB Newsletter 2020 – Issue 11

Like all of you, the UTB team have had ‘same same, but different’ experiences of 2020. However, there is something that I know has sustained us all through the challenging times when ‘normal’ has seemed like a long lost memory. Our work with you.
Being able to connect with you, and continue to help you, through these times has truly been one of the joys of 2020. Thank you for that opportunity.

VIEW POST

Top tips for working from home by a remote working team

  With Google Drawings a lot of people don’t realise that it actually sits inside Google Docs. Inside Google Docs you actually have the Google Drawings tool. Under insert you’ve got Drawings and now there are two places that you can get a Drawing from. The ‘New’ is going to

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

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

 

Sign Up Now
To Get The Latest Updates