Chapter 8 | 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 | 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 | |
Computer System Requirements .................................................................................... | 108 | |
Pocket Sheet Errors ........................................................................................ | 108 |
9