beautypg.com

Pocket sheet – Casio PV-S460/PV-S660 User Manual

Page 11

background image

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

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

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

Chapter

8

This manual is related to the following products: