9
Pocket Sheet ....................................................... 83
Entering the Pocket Sheet Mode ....................................................................... 83
Pocket Sheet Basics ......................................................................................... 83
Creating a New Sheet from Scratch ................................................................................. 84
Making a Cell the Active Cell .......................................................................................... 85
Selecting a Range of Cells ............................................................................................... 85
Jumping to a Specific Cell in a Sheet .............................................................................. 85
Inputting Data Into a Cell ................................................................................... 86
General Input Rules ......................................................................................................... 86
Cell References ................................................................................................................ 86
Relative Cell References .................................................................................................. 87
Absolute Cell References ................................................................................................. 87
Mixed Cell References ..................................................................................................... 88
Using the On-screen Keyboards ...................................................................................... 88
Inputting Mathematical Expressions ................................................................................ 89
Inputting Text ................................................................................................................... 91
Input Example ................................................................................................... 92
Example Data ................................................................................................................... 92
Controlling the Appearance of a Cell ................................................................. 93
Changing the Format Settings of a Cell ........................................................................... 93
Specifying Cell Border Lines ........................................................................................... 96
Row and Column Operations ............................................................................ 97
Changing the Width of a Column .................................................................................... 97
Scroll Freezing Rows and Columns ................................................................................. 98
Inserting Rows ............................................................................................................... 100
Inserting Columns .......................................................................................................... 101
Deleting Rows and Columns .......................................................................................... 101
Sheet Operations ............................................................................................ 102
Opening a Sheet ............................................................................................................. 102
Displaying the Input Screen ........................................................................................... 102
Saving a New Sheet ....................................................................................................... 102
Saving an Existing Sheet Under a New Name ............................................................... 102
Exiting a Sheet ............................................................................................................... 103
Renaming a Sheet ........................................................................................................... 103
Cut, Copy, Paste, Clear ................................................................................... 103
Cutting and Copying Cell Data ...................................................................................... 103
Pasting Cell Data ............................................................................................................ 104
Copying a Relative Cell Reference ................................................................................ 105
Copying an Absolute or Mixed Cell Reference ............................................................. 105
Clearing Cell Data .......................................................................................................... 105
Searching for Data in a Sheet ......................................................................... 106
To search for data in a sheet ........................................................................................... 106
Setting Sheet Calculation, Gridline, and Protect Options ................................ 107
Date and Size Information ............................................................................... 107
Displaying Date and Size Information ........................................................................... 107
Pocket Sheet Sync .......................................................................................... 108
Pocket Sheet Errors ........................................................................................ 108
Chapter
8