Spreadsheet for iOS

Users have an opportunity to create a spreadsheet by tapping the Spreadsheet tab under the Create Menu. A spreadsheet similar to this will appear:

Entering Text Into A Cell

Before a user begins typing, they will need to select the specific cell they wish the information to live. Then selecting the “ABC” button in the top right corner, a text box will appear across the top of the sheet— where a toolbar would typically reside. Users must type the text into this text box and either tap enter, or the check on the far right of the the text box. 

This process must be done for each individual cell. 

Formatting A Cell

To customize the formatting of a cell, users will select the Grid button, directly to the left of the “ABC” icon. This will present a tool bar in place of the text box. 

1. Cell Format: The very first icon willl allow users to customize the cell format. Begin by selecting the cell to format, then simply tap the icon “ABC 123” inside of the rectangle and a drop down menu will appear. 

Tap whichever formatting style is appropriate. 

2.Merging Cells: Users will begin by selecting the cells they wish to merge. Ensure the cells are selected by the color highlight around the collection of cells. Then select the second icon on the tool bar, represented by a rectangle encompassing two outwardly facing arrows. 

3. Unmerging Cells: If a cell has been merged, users have the option to unmerge the cell. Ensure the cell is selected, and tap the icon directly to the right of the Merging Cell Icon, represented by a rectangle encompassing two inward facing arrows. 

4. Text Positioning Within A Cell: Directly to the right of the Merging/Unmerging icons, is a series of 3 icons representing text’s positioning within the cell: 
Ensure the cell is selected. 

The first icon with Upward Facing Arrow will position the text at the top of the cell. 

The second icon with both an Upward Facing Arrow and A Downward Facing Arrow will position the text in the center—laterally— of the cell. 

The third icon with a Downward Facing Arrow will position the text at the bottom of the cell. 

5. Adding And Deleting Columns And Rows

The final four icons allow users to Add and Delete Columns and Rows. The first two add: 

The first icon, represented by the series of Horizontal Rectangles will add a row above the selected cell. 

The second icon, represented by the series of Verticle Rectangles will add a column before the selected cell. 

The next icons delete:
 

The first icon, represented by the series of Horizontal Rectangles will delete the row containing the selected cell. 

The second icon, represented by the series of Vertical Rectangles will delete the column containing the selected cell. 

 

Text Customizations

Users have some standard text customizations for individual cells. Begin by tapping the Upper Case T, directly next to the the Grid Icon, this will prompt the following tool bar:

FontSelect the first textbox, and a drop down menu will appear, allowing users to select from a large variety of fonts. Once designated, the selected cell will adopt that font. 

Font Size: Directly to the right of the Font text box, is the font size box. Designate numerically the size of the font. Once designated, the selected cell will adopt that font size.  

Bold: Users select the “B” if they wish the text within the selected cell to be bolder.  

Italicize: Users select the slanted line if the wish the text within the select cell to be italicized. 

Underline: Users select the underlined U if the wish the text within the cell to be underlined.

Alignment: Users can designate a particular alignment for the cell. Tap the icon represented by multiple vertical lines, and select which alignment you wish the selected cell to adopt.   

Font Color: Select the capital A icon, and a drop down menu with a large variety of colors will appear. Select a color, and the font within the selected cell, will adopt the color. 

Cell Color: Select the paint bucket icon, and a drop down menu with a large variety of colors will appear. Select a color, and the background of the selected cell will adopt that color. 

Search 

Users have the option to search a spreadsheet for a certain term. Click the Magnifying Glass icon in upper right of the screen. This will prompt a search bar in place of a tool bar similar to this: 

Users will type in the term the wish to search and press enter. All matching terms will be highlighted. Additionally, the very bottom of the page will display the grand total of matching terms. 

 

Undo, Redo, Print & Done

In the top left corner, some additional actions are available.

The leftward facing arrow is the Undo function. Users may use this to negate the most recent action they took on the document. 

The rightward facing arrow is the Redo function. This function is only available if the user has previously used the Undo function and wishes to negate that Undo action. 

The ellipsis icon prompts a drop down window with an option to print. 

Lastly, the done option prompts a drop down menu with a variety of saving options. A user simply taps the option desired and the file will be saved to the specified destination.

Was this article helpful?
0 out of 0 found this helpful
Have more questions?
Submit a Ticket