background image

103

Chapter 8 Pocket Sheet

To freeze a row and column at the same time

1. Tap the cell below the row and to the right of the column you want to

freeze.

To freeze column A and row 1, for example, you would tap cell B2.

2. Tap the Menu Bar icon to display the menu bar, and then tap Option –

Freeze.

To unfreeze rows and columns

If a row and/or column is frozen on the current sheet, tap the Menu Bar
icon to display the menu bar, and then tap Option – Freeze to unfreeze
them.

Inserting Rows

1. Select the location in the sheet where you want to input the rows.

The number of cells you select determines the number of rows that are
inserted. Selecting C1 inserts a single row at row 1. Selecting C1 and
C2 inserts two rows at rows 1 and 2.

Existing rows will be shifted downwards to make room for the newly
inserted rows.

2. Tap the Menu Bar icon to display the menu bar, and then tap Option –

Insert.

3. On the dialog box that appears, tap Rows to perform the row insert

operation in accordance with the cells you selected in step 1.

Содержание PV-S250

Страница 1: ...ever you enter the Quick Memo Mode Tap in the upper right corner of the screen to exit the Quick Memo Mode and return to the screen from which you originally entered it Quick Memo Categories There are three Quick Memo categories As with categories in other modes Quick Memo categories let you group your memos for easier management To select a Quick Memo category Tap the Quick Memo category button t...

Страница 2: ...ool Tap this tool to cycle through line thickness in the sequence medium fi thick fi thin fi medium etc Dragging the stylus on the screen while this tool is selected draws a line Note that you can control the type of line produced by the pencil tool with the line tool described below Eraser Tool Tap this tool to cycle through eraser thickness in the sequence medium fi thick fi thin fi medium etc D...

Страница 3: ...tool to undo the last draw operation you just performed Creating a New Quick Memo Use the procedures in this section to draw the figures you want in a Quick Memo To input a new Quick Memo 1 Enter the Quick Memo Mode 2 Tap the category button to select the category where you want to save the Quick Memo 3 Use the drawing tools to draw the figure you want To clear all Quick Memo screen contents tap C...

Страница 4: ...s on the display tap List 1 3 4 2 This is the Quick Memo list screen 2 Tap the category button to specify the category whose Quick Memos you want to view Selecting displays the Quick Memos in all categories 3 Use the scroll buttons to scroll through the Quick Memos in the currently selected category 4 When the Quick Memo you want to recall is on the screen tap it with the stylus to select it 1 Cat...

Страница 5: ... store it as a Quick Memo screen The following is a list of screens that you can copy with the screen copy feature Data that can be screen copied All list and data screens All calendar screens 1 2 3 month Weekly Scheduler Daily Scheduler To Do List Reminder List All data screens Screens listing periodic totals by expense types or payment types page 69 All list and data screens All list and data sc...

Страница 6: ... record a screen copy 2 Tap the Menu Bar icon to display the menu bar and then tap Option Screen copy The PV Unit switches to the Quick Memo Mode with the new screen copy on the display Make any additions or changes if you want and then store the image by tapping Save ...

Страница 7: ... Menu icon to display the Mode Menu and then tap Pocket Sheet 2 1 This is the Pocket Sheet list screen which appears first when you enter the Pocket Sheet Mode Pocket Sheet Basics With Pocket Sheet you can open up a blank sheet and build the sheet you want from scratch The following sections describe how to open a new sheet and how to perform some of the most basic sheet operations Chapter 8 Pocke...

Страница 8: ...tion exceeds the maximum limit about 32KB the excess cell data is automatically cut off In this case the sync operation ends normally with no indication that the data was cut off This means you should always check sheet contents visually after a sync operation is complete A cell is referred to using its cell reference which is made up of the cell s column name and row number This means that the ce...

Страница 9: ... the range of cells you want to select The cells become highlighted as you drag across them Dragging straight left or right selects a range of cells in the same row Dragging straight up or down selects a range of cells in the same column Dragging diagonally selects a block of cells multiple rows and columns Jumping to a Specific Cell in a Sheet Important You cannot jump to a cell located inside a ...

Страница 10: ...s into sheet cells It also contains detailed information on the various cell functions that are available General Input Rules The following are the general rules that you should observe whenever inputting data Anything you enter on the keyboard is input into the sheet s active cell You can input up to 256 characters into each cell Mixing text and numbers inside the same cell causes everything in t...

Страница 11: ...reference is one that references a cell in relation to the cell where the reference is made Note the following examples Absolute Cell References An absolute cell reference is one that references a specific cell no matter where it is located in relation to the cell where the reference is made A reference is made absolute by inserting a dollar sign in front of its column name and row number Note the...

Страница 12: ...thin a sheet causes an on screen keyboard to appear Tapping the button above the text keyboard changes to the numeric keyboard Tapping the button above the numeric keyboard changes to the text keyboard Tapping displays a menu of built in functions Meaning Contents of cell A1 The column reference A is absolute and the row reference 1 is relative Contents of cell A1 The column reference A is relativ...

Страница 13: ...d flush right in the cell If the result of a mathematical expression is longer than the cell that contains it the contents of the cell are replaced by a string of marks This is to let you know that the cell contains a value but the value cannot be displayed If this happens try making the cell wider page 100 To input a mathematical expression 1 Make the cell where you want to input the expression t...

Страница 14: ...lue to power specified by right value Absolute value of value in A1 Average of values in cells A1 through D5 Number of values in cells A1 through D5 Number of non blank cells in cells A1 through A7 4 Rounds up to the nearest even number 8 Rounds down to the nearest integer Greatest value of those in cells A1 through D5 Least value of those in cells A1 through D5 1 Integer result when left value is...

Страница 15: ...ht If a text string is longer than the cell the extra text is allowed to extend into the next cell to the right in the sheet display as long as the neighboring cell does not contain any data If it does the extra characters are cut off in the sheet display If an input value is longer than the cell that contains it the contents of the cell are replaced by a string of marks This is to let you know th...

Страница 16: ...of the values from cell A2 through cell B5 and then multiplies it by the value in cell C2 4 1 Open a sheet and then tap cell C5 2 Perform the following keys operations to input characters into the input field SUM 3 Next use the stylus to drag from cell A2 to cell B5 so all the required cells become highlighted 4 Remove the stylus from the screen to input the range of selected cells into the input ...

Страница 17: ...the format of data inside individual cells or a range of cells The format settings are numeric value category monetary unit percent number of decimal places alignment text style bold or normal comma separators for values and cell lock Changing the Format Settings of a Cell 1 Make the cell whose format you want to change the active cell page 87 You can select a single cell or a range of cells 2 Tap...

Страница 18: ...ist of numeric value categories You can specify whether a number should be treated as simply a numeric value a monetary value or a percent The following shows the available settings and their meanings For the monetary units and percent the applicable symbol is appended automatically to the value in the cell When percent is selected as the category setting a value of 0 1 becomes 10 1 becomes 100 10...

Страница 19: ...symbol only The symbols for the other currencies are fixed Use the on screen keyboard to type up to three letters for the currency to which you want to change You could input DEM for German marks FRF for French francs etc After inputting the letters you want tap Set to save them The letters you input above replace the euro symbol in the Category list ...

Страница 20: ...cimal point is located wherever you input it Alignment Tap the L arrow next to the Alignment box to display a list of alignment settings You can select from among General Left Center and Right Selecting General causes text to be aligned left and numbers aligned right Bold Tap the check box to toggle bold text on checked and off unchecked Comma Tap the check box to toggle comma separators every thr...

Страница 21: ...s located is unprotected even if the cell is locked The following shows the relationship between the cell lock and sheet protection Specifying Cell Border Lines 1 Select the range of cells whose borderlines you want to change See Making a Cell the Active Cell on page 87 2 Tap the Menu Bar icon to display the menu bar and then tap Option Border Cell Status Locked Locked Unlocked Unlocked Sheet Stat...

Страница 22: ...of cells either by dragging the boundary to the width you want or by specifying width value that represents a number of display dots To change the width of a column by dragging its boundary In the black bar that shows the column names A B C at the top of a sheet drag either of the white boundary markers of the cell left or right to change its width You can drag a column boundary marker as far as t...

Страница 23: ... of 3 to 130 4 When the setting you want is displayed tap Set to apply it Tapping Esc closes the Width dialog box without applying any changes you have made in the setting Scroll Freezing Rows and Columns Scroll freeze is a technique you can use to stop rows and columns from scrolling when you tap the scroll bars on the screen This is helpful when you want to leave row and column titles frozen on ...

Страница 24: ...column B tap cell C 2 Tap the Menu Bar icon to display the menu bar and then tap Option Freeze To freeze a row only 1 In the far left column of the displayed sheet tap the cell in the row below the row you want to freeze To freeze row 1 for example you would tap cell 2 in the far left column To freeze both rows 1 and 2 tap cell 3 2 Tap the Menu Bar icon to display the menu bar and then tap Option ...

Страница 25: ...ay the menu bar and then tap Option Freeze to unfreeze them Inserting Rows 1 Select the location in the sheet where you want to input the rows The number of cells you select determines the number of rows that are inserted Selecting C1 inserts a single row at row 1 Selecting C1 and C2 inserts two rows at rows 1 and 2 Existing rows will be shifted downwards to make room for the newly inserted rows 2...

Страница 26: ... the column insert operation in accordance with the cells you selected in step 1 Deleting Rows and Columns 1 Select the location in the sheet where you want to delete rows or columns The number of cells you select determines the number of rows or columns that are deleted Selecting C1 deletes row 1 or column C Selecting C1 and D1 deletes columns C and D Selecting C1 and C2 deletes rows 1 and 2 Rema...

Страница 27: ... Screen You can use any one of the following two operations to change from a sheet screen to the input screen Tap the input field Tap the currently selected highlighted cell To change back to the sheet screen from the input screen tap Esc Saving a New Sheet 1 After inputting data into a sheet tap the Menu Bar icon to display the menu bar and then tap Edit Save 2 Type in up to 32 characters for the...

Страница 28: ...play the menu bar and then tap Edit Close If there are unsaved edits in the sheet tapping Esc displays a screen for saving the sheet Type in a name and then tap Save to save the sheet If you want to quit without saving the sheet tap Esc Renaming a Sheet 1 Display the Pocket Sheet list screen 2 Tap the sheet you want to rename so it is highlighted 3 Tap the Menu Bar icon to display the menu bar and...

Страница 29: ...s The border specification however is not included You can use the Paste command page 108 to paste the contents of the clipboard into another cell or range of cells Copying Cell Data 1 Select the cell or range of cells that contains the data you want to copy See Making a Cell the Active Cell on page 87 2 Tap the Menu Bar icon to display the menu bar and then tap Edit Copy The data is copied to the...

Страница 30: ...data is pasted from the clipboard into the currently active cells The pasted data includes format settings page 95 as well as any text numbers and mathematical expressions No border specification is included Note A paste operation that causes the maximum number of rows 999 or columns 26 to be exceeded causes the following message to appear This operation will push some data outside the sheet Conti...

Страница 31: ...Reference Since absolute cell references are absolute they remain the same even when the expression is moved With mixed cell references the absolute part remains the same while the relative part changes according to the location of the expression Note the following example A 2 B2 C 2 D2 A 2 B5 D 2 E5 A B C 1 2 3 4 5 PASTE Clearing Cell Data 1 Select the cell or range of cells whose data you want t...

Страница 32: ... in a sheet Note The Pocket Sheet search function checks cell data only for the characters you specify It does not check calculation formulas and functions assigned to cells The search starts from the cell that is currently selected in the sheet and proceeds to the right of the selected cell The contents of cells located inside a row or column that is frozen are not searched To search the contents...

Страница 33: ...ill be shown on the above screen 4 Input up to 12 search characters 5 Tap Exe to start the search The message Data item not found appears if there is no data in the sheet that matches the text you specify 6 To search for the next occurrence of the same data tap Next You can repeat this step as many times as necessary 7 After you are finished searching for data tap Esc to close the search screen Fo...

Страница 34: ...alculations manually by executing Menu Bar Option Calc Now Check Gridlines to display the sheets gridlines Check Protect Sheet when you want to protect the contents of the sheet from being changed Note that sheet protection is related to cell locking described under Lock on page 99 4 After the settings are the way you want tap Set to apply them Date and Size Information You can use the following p...

Страница 35: ...OK to close the dialog box Pocket Sheet Sync Pocket Sheet Sync for Microsoft Excel 95 97 2000 synchronizes Pocket Sheet data stored in your PV Unit with data in files created using Microsoft Excel 95 97 2000 For details on using Pocket Sheet Sync see the documentation contained on the CD ROM that comes with your PV Unit Computer System Requirements The following are the minimum computer system req...

Страница 36: ...ed cell to be outside the sheet Any copy operation or row or column insert operation that causes the length of a function to exceed 256 characters Mathematical error Adding a large number of mathematical expressions to a sheet for which Auto Calculation is turned off can cause the ERR message to appear Parentheses can be nested up to 10 times inside a single calculation Referencing of other cells ...

Отзывы: