User Manual

9-11
Absolute Reference Names
If you want the row or the column, or both the row and the column parts of a cell reference
name to remain the same to matter where you paste them, you need to create an absolute cell
reference name. You do this by affixing a dollar sign ($) in front of the part of the cell reference
name you want to remain unchanged. You have three options when using the dollar sign ($)
to create an absolute cell reference name: absolute column with relative row ($A1), relative
column with absolute row (A$1), and absolute row and column ($A$1).
u To input the absolute cell reference name symbol ($)
When inputting a cell reference into a spreadsheet cell, press 2($).
For example, the following key operation inputs the absolute cell reference name = $B$1.
!.(=) 2($) al(B) 2($) b
k Copying and Pasting Cell Contents
You can copy the contents of one or more cells and paste them into another location. Once
you perform the copy operation, you can copy the contents to multiple locations, if you want.
u To copy and paste spreadsheet data
1. Select the cell(s) you want to copy.
• See “To select cells” (page 9-5) for more information.
2 Press 2(EDIT) 2(COPY).
• This will go into paste standby for the selected data, indicated by the 1 menu item
changing to (PASTE).
• You can exit the paste standby at any time before you perform step 4 below by pressing
J.
3. Use the cursor keys to move the cell cursor to location where you want to paste the data.
• If you selected a range of cells in step 1, the cell you select with the cell cursor will be the
upper left cell of the paste range.
• If the location you select is within the range that you copied, performing step below will
cause the exiting data to be overwritten with the pasted data.
4. Press 1(PASTE).
• This will paste the copied data.
• To paste the same data in other locations, repeat steps 3 and 4.
5. After you are finish pasting the data, press J to exit paste standby.