How to begin.
Using an iPhone or iPad. Apple has it's own version of spreadsheets which is contained in their App iWork. This includes Numbers, Pages and Keynote. Search for the Numbers App in the Apple App Store and download to either iPhone or iPad.
The Numbers App icon looks like the image below.
Create New Spreadsheet
Once the App is downloaded open it. Apple comes with some spreadsheet templates which can be used or create your own. To create your first spreadsheet tap the blank spreadsheet labeled Create New as per this image below.
Once the Create New spreadsheet opens it allows the option of using the Templates spreadsheets or a Blank Spreadsheet. Tap the spreadsheet labeled Blank. The following blank spreadsheet opens.
Row 1 is grey called a Header Row and Column A is also grey called a Header Column. By default this Table occurs first. The Header Row and Header Column are frozen. Great if used for Labels that will remain visual whilst moving around the spreadsheet. There are options to change to different Tables prior to entering any data into the spreadsheet. To do this look at the icons above the spreadsheet and tap icon that looks like a Paintbrush. A menu opens as per the image below. The following Menu options are now available. Table, Headers, Cell, Format.
Reset Tables
Tap the Table label and more table templates are now available. The top left Table is the default Table. Select a different Table to suit the theme of a new spreadsheet. On the default spreadsheet tap the Label Headers. This gives an opportunity to change the Header Row and Header Column which are frozen. The following image shows the options available once the Header label has opened.
Unfreeze Columns and Rows.
Tap the + sign on the Header Row to freeze 2 Rows or tap the - sign and remove the Header Row. If the Header Row and Header Column are at 0 then the blank spreadsheet will be similar to an Excel default blank spreadsheet in appearance. Tap the Freeze Rows and Freeze Columns to the left of the slider to ensure all Rows and Columns are unfrozen. The spreadsheet will now appear as the image below.
Tap anywhere into the spreadsheet and the format menu will disappear. Data can be entered into the cells of the spreadsheet. Should Header Rows or Header Columns need to be frozen in the future, then tap the Paintbrush Icon, Headers and freeze the number of Rows or Columns desired.
