Neoxeekhrobe
neoxeekhrobe@gmail.com

PocketSheet Tutorials

Creating a Worksheet

Selecting a range of cells

Moving to a specific cell

Cut, copy and paste functions

Making the data bold

Alignment of Data

Inserting columns or rows

Deleting columns or rows

Applying borders around cells

Column width

Using Formulas

Fixixng certain rows and columns to screen area while others scroll

Unfreezing

Searching Data

Adding a currency sign

User defined currency sign

Decimal Places

Converting numbers to percentages

Calling the contents of one cell into the other

Using Functions and the three types of References

List Of Functions

Protecting cells and sheets

Creating a Worksheet

Start Pocket Viewer

Tap on the Pocket sheet icon ( )

In the Pocket Sheet List screen, tap on the New button ( ) at the top of the screen

The size of each sheet is 32 kb

The size of each cell is upto 256 characters

1- On Screen Keyboard toggle button 2- Data Entry field 3- Columns names ( A-Z) 4- An active/current cell (named A1) 5- Row numbers ( 1-999 ) 6- Function Selector Key 7- On Screen Non-QWERTY Keyboard

Tap on the On screen keyboard toggle button to change the keyboard layout to a QWERTY keyboard ( )

Now tap on the keyboard to enter the following text in the cell A1

Tap on the cell A2, below the current cell to bring it in edit mode (active)

Tap on the keyboard to enter the numbers 1234567890

Tap on the cell B1, right to the cell A1. If the number entry is larger than the cell width then it is replaced by a string of # mark

Tap on the keyboard to enter the value b1

Tap on the cell B2 ( )

Tap on the Menu Bar icon in the lower right corner on the green strip at the bottom of the PocketViewer Screen

Select Save As from the Edit menu ( )

Enter a name for the worksheet ( )

Tap the Save button at the top right corner of the screen

After the messages tap twice on the Esc icon in the lower right corner on the green strip at the bottom of the PocketViewer Screen

In the Pocket Sheet List screen tap on the 1ws file to open it again

Tap on the Menu icon on the green strip at the bottom of the PocketViewer Screen to exit Pocket Sheet

Selecting a range of cells

Tap on a cell

Darg the stylus on the screen to select all the cells you want

Moving to a specific cell

Note: Frozen cells cannot be accessed through this method

Tap on Menu Bar in the lower right coner of the green strip at the bottom of the screen

From the Edit menu select Goto

In the Goto screen enter the name of the cell. Example g3 or H675

Tap the Exe button in the top right corner of the screen

Cut, copy and paste functions

Select a cell or a range of cells

Tap on the Menu Bar icon in the lower right corner of the screen

Tap on the Edit menu

Select the function you want pocket sheet to perform from the drop down list

Note: In order to paste select the same number of other cells and repeat the above steps

Making the data bold

Select the cell

Tap on Menu bar iocn in the lower right corner of the screen

Tap on Options

Select Formats ( ) from the drop down list

Near the bottom of the screen check the box named Bold

Tap on the Set button in the top right corner of the screen

Alignment of Data

Select the cell whose data you want to align

Tap on Menu bar iocn in the lower right corner of the screen

Tap on Options

Select Formats ( ) from the drop down list

Tap on the down arrow ( ) button under Catogery

Inserting columns or rows

Select a cell

Note: A column will be placed to the left of the column whose cell you selected. A row will be placed above the row whose cell you selected

Tap on the Menu Bar icon in the lower right corner of the screen

Tap on Option

Select Insert from the drop down list

On the Insert dialog box tap on column or row to insert colum or row respectively

Deleting columns or rows

Select a cell in a column or row that you want to be deleted

Tap on the Menu Bar icon in the lower right corner of the screen

Tap on Option

Select Delete from the drop down list

On the Delete dialog box tap on column or row to delete a colum or row respectively

Applying borders around cells

Select the cells from A1 to B3

Tap the Menu Bar icon in the lower right corner of the screen

Tap on the Options menu

Tap on the Border option from the drop down list

Select one of the four border styles

	No border
	Border around each cell in the selection
	Normal border around the selection
	Thick border around the selection

Tap the Exe button

Column width

Tap on the column boubdary between two column headers ( )

Drag the stylus to increase or decrease the size of column

By specifying a value

Select the cell of a column whose width you want to change

Tap on the Menu Bar icon in the lower right corner of the screen

Tap on Option

Select Width from the drop down list

Enter the value in pixels ( )

Tap on the Set button

Using Formulas

Formulas always start with an = sign

Select cell A1

Enter the value 2

Select cell A2

Enter the value 4

Select cell B1

Enter the following formula

=A1+A2

Tap on some other cell

Cell B1 will show the result of the formula

Fixixng certain rows and columns to screen area while others scroll

Select a cell

Note: All the rows above the cell and all the columns to the left of the selected cell are going to be freezed, meaning they wont move with scrolling

Tap on the Menu Bar icon in the lower right corner of the screen

Tap on Options menu

Select Freeze

Note: Any thing to the left and above the solid line is frozen

Examples

	Cell Selected Column Freezed Row Freezed B1 A -
	Cell Selected Column Freezed Row Freezed A2 - 1
	Cell Selected Column Freezed Row Freezed B2 A 1
	Cell Selected Column Freezed Row Freezed A3 - 1 and 2

Unfreezing

Tap on the Menu Bar icon in the lower right corner of the screen

Tap on Options menu

Select Freeze

Searching Data

Tap on Esc icon in the lower right corner of the screen

Select a cell from which you want to start searching

Note: Cells that ae frozen and cells on the left of a selected cell will not be searched

Tap on the Menu Bar icon in the lower right corner of the screen

From the Edit menu select Search from the drop down list

In search window type a query of 12 characters

Tap on the Exe button on the top of the Search screen

To search for the next occurrence of the same data, tap the Next button at the top of the screen

Adding a currency sign

Select the cell A1

Enter a value of 23

Select some other cell

Reselect the cell A1

Tap on Menu bar iocn in the lower right corner of the screen

Tap on Options

Select Formats ( ) from the drop down list

Tap on the down arrow ( ) button under Catogery

Select one of the four currency signs ( ) from the drop down list

Tap on Set button on the top right corner of the screen

User defined currency sign

Select the cell A1

Enter a value of 2

Select some other cell

Reselect the cell A1

Tap on Menu bar iocn in the lower right corner of the screen

Tap on Options

Select Formats ( ) from the drop down list

Tap on the down arrow ( ) button under Catogery

Select the Euro sign from the bottom of the drop down list

Tap on the edit button ( ) on the right

Delete the Euro sign and enter a new currency sign

Tap on the Set button on the uppre right corner

Again tap on the Set button

Decimal Places

Select the cell A1

Enter a value of 2

Select some other cell

Reselect the cell A1

Tap on Menu bar iocn in the lower right corner of the screen

Tap on Options

Select Formats ( ) from the drop down list

Tap on the down arrow button under Decimal places

Select a number from the drop down list ( ) for the number of decimal places after a decimal

Note: Selecting Free allows you to place a decimal where ever you want and the number of places that you want

Converting numbers to percentages

Select the cell A1

Enter a value of 2

Select some other cell

Reselect the cell A1

Tap on Menu bar iocn in the lower right corner of the screen

Tap on Options

Select Formats ( ) from the drop down list

Tap on the down arrow ( ) button under Catogery

Select the Percent ( % ) sign from the list

Tap on Set button on the top right corner of the screen

Note: When percent is selected as the category setting, a value of 0.1 becomes 10%, 1 becomes 100%, 10 becomes 1000%, etc

Calling the contents of one cell into the other

Using the names of other cells in a cell means that you want the contents of those cells whose names you are using.

This is known as Cell References

There are three types of cell references

• Relative
• Absolute
• Mixed

Note: This is very useful when you are copying the contents ( with the name of other cell/s) of a cell to other cell

Using Functions and the three types of References

Tap on the cell A1

Enter the value 15

Tap on the cell A2

Enter the value 10

Tap on the cell A3

Enter the value of 5

Tap on cell C4

Tap on the Function Selector key ( fx ) on the non-qwerty keyboard

Select the function SUM() at the end of the list that appears ( )

Select the cells from A1 to A3 ( )

Tap on some other cell and the result of the sum of the values in cell A1, A2 and A3 are shown in cell C4

Change one of the values, tap on the Next key and the result in cell C4 will change too

Relative Reference

Note: A1:A3 is known as relative reference, meaning the three cells before this cell in row number and in the second column on the left

Selects the cells A1 to A3

Tap on Menu Bar and select Copy from the Edit menu

Selects the cells B2 to B4

Tap on Menu Bar and select Paste from the Edit menu

Similarly Copy cell C4

Paste it in the cell D5

Note: The formula will automatically convert to =SUM(B2:B4)

The result in cell D5 will be 10

Absolute Reference

Tap on cell C4

Open the qwerty keyboard

Tap on the SMBL key

In the Data entry field add a $ mark before both As and 1 and 3 ( )

Tap on cell C4 once again

Copy the cell

Tap the cell D5

Paste altered formula in it

The result in cell D5 will be 30

Note: With absolute references the formula does not changes as it is copied to some other cell

Mixed Reference

Delete the $ mark from A3 in the formula in cell C4( )

Copy and paste the formula in cell D5

The result in cell D5 will be 42

Note: A1 in the formula was absolute so that did not change but since the formula is in D5, the non absolute argument A3 changed to the name of the cell that was one row number less than D5 and was in second column to the left (B4). This formula being in cell D5, summed up all the values from A1 to B4. Cell A4 and cell B1 had no values

Tap on cell B1

Enter the value 3

The result in cell D5 will change from 42 to 45

Some Examples

List Of Functions

Tap on the Function Selector key ( fx ) on the non-qwerty keyboard ( )

Protecting cells and sheets

To Lock cells

Tap on the cell

Tap on Menu bar iocn in the lower right corner of the screen

Tap on Options

Select Formats ( ) from the drop down list

Near the bottom of the screen check the box named Lock

Tap the Set button in the top right corner

To Lock sheets

Open the sheet

Tap on Menu bar iocn in the lower right corner of the screen

Tap on Options

Select Sheet ( ) from the drop down list

Check the box named Protect sheet

Tap the Set button