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 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

Computer System Requirements ....................................................................................

108

Pocket Sheet Errors ........................................................................................

108

9