Google Sheets

For all Google Sheets support - click the link for access to Google Sheets Help

Google Sheets

Sheets is Google’s answer to Microsoft Excel, in your web browser or app. It is an online, collaborative spreadsheet program that is part of Google Drive and Google Workspace for Education. As long as you are connected to the internet, all your changes are saved instantly.

You can access Sheets by going to sheets.google.com or you will see your Sheets files in your Drive.

Creating a new document

To create a new Sheets file, simply type sheets.new into the address bar at the top of your browser page.

In Drive, simply click the +New button or the Waffle button to launch Sheets.

The Toolbar

The main toolbar along the top of a Sheets window houses some key features that you probably won’t use each time but it’s extremely useful to know about. It also tells you when things are saved. As you type or make other changes, the All changes saved in Drive text will change to Saving.

File

  • Make a copy – Make a duplicate of the document you are in.

  • Download as – Download your document in other formats, such as Excel or PDF.

  • Email as attachment – Send your document as an email, can attach as other formats, such as Excel or PDF.

  • Version History – See all the changes you and others have made to the document or revert it to earlier documents.

Edit

  • Delete row or Delete column – Delete the row or column that the selected cell is in.

  • Delete cells and shift left or Delete cells and shift up – Delete the data from the selected cell and move all other data in the row or column left or up into its place.

Insert

  • Row above or Row below – Insert an empty row above or below the selected cell.

  • Column left or Column right – Insert an empty column to the left or right of the selected cell.

  • Cells and shift right or Cells and shift down – Move the selected cell right or down and place an empty cell in its place.

  • Chart – Create a graph based on the data in your spreadsheet.

  • Drawing – Create pictures, flowcharts, diagrams and more.

  • Tick box – Add a small tick box to a cell, click it to tick it then click it to untick it.

  • Note – Add a small note to a cell, only displays if you hover your mouse over the cell

Formatting Toolbar

The image below shows the main editing features of Sheets, the Format data option lets you quickly change the format of a cell for example from plain text in to currency as well as move the decimal place. The other settings allow you to add borders, merge cells, change the text formatting and how the cell reacts to text. There are also quick buttons for adding in links, comments, charts and filters.

For all Google Sheets support - click the link for access to Google Sheets Help