Getting to know the spreadsheet editor
Create a simple empty spreadsheet and get to know the spreadsheet editor.
You might have already created your first spreadsheet in Rows when you first signed up, but it's worth going through the spreadsheet editor in a little more detail. The spreadsheet editor has many elements common to other spreadsheet applications, but also some unique features too.
The layout of a Rows spreadsheet
In other spreadsheet applications, a spreadsheet is organized into sheets. Typically you switch between sheets with tabs at the bottom.
In Rows, the equivalent of a sheet is a Table which is where you put your data. However, unlike other applications, you also group your Tables into Pages.
You can access these elements in the left-hand navigation section where you can switch between different Tables and Pages.
Pages help you lay out your spreadsheet when you're ready to insert it into a professional-looking report. You can learn more about the potential of Pages by putting a spreadsheet "live".
But first things first, let's take a closer look at...
The spreadsheet editor
Here’s a guide to the main features of the Rows editor and some references for further reading.
|The Navigation Section||Navigate your spreadsheet and create pages and tables.|
Hover your mouse over a page or table title to access further actions that will allow you to create new page elements such as the Table, Form or Chart.
|The Formula Bar||Enter and edit formulas in the currently selected cell, just like in other spreadsheet applications.|
|The Actions Toolbar||Perform standard actions on the contents of tables.|
|The Collaboration Menu||Share your spreadsheet with others and invite them to collaborate:|
|The Table Behavior Menu||Configure how the table behaves when people view your spreadsheet in “live” view. For example, you can configure your table to act as a form that users should fill out.|
|The Table Actions||Perform various actions on the entire table:|
Now that you understand the spreadsheet editor, try creating a spreadsheet from a template.