Moving and Resizing Columns or Rows
To move or resize a row or column, you must first select the row or column. Once selected, to move, press on the blue bar (not the small
lines on the blue bar). Drag and drop to the desired location. To resize a column or row, tap and drag on the small lines on the blue bar.
Basic Formula Information
Example: Sums
Formulas are easily found in the formula menu. Here is an example of
how to insert a formula. To insert a sum formula, double-tab the cell in
which you want your answer to appear. Then tap the “=”. Tap SUM on
the keyboard. Finally, tap the checkmark to confirm and see the answer.
Adding and Organizing Sheets
Adding a Sheet
To add a sheet, click on the tab with the “+” icon.
Moving Between Sheets
To move to a desired sheet, tap the appropriate tab. If you have multiple tabs, tap and scroll/swipe left and right until the desired tab is
found. Tap once on that tab.
Charts
Placing a Chart
Tap the insert button, choose Charts. Scroll
through the options and then tap the desired
chart. Drag the chart where you want it to appear on the sheet.
Renaming a Sheet
To rename to a sheet, first double-tab on the name of the tab. Then
select the text and begin typing a new name.
Changing the Order of Sheets
To reorder the sheets, tap and hold on the sheet you wish to move until the title becomes shadowed. Then you can drag and drop in the desired location.
Duplicating or Deleting a Sheet
Associating a Chart with Existing Data
Double-tab the chart. On the spreadsheet, tap
and hold, dragging across the cells which you
wish to be included in the chart.
To switch whether rows or columns are included, tap the cog in the top right-hand corner of your screen. When
you are finished with associating the data to the chart, click Done.
To duplicate or delete a sheet, tab the title of the sheet. Then tap
again and choose Duplicate or Delete.
33