Loading ...
Loading ...
Loading ...
copying and then pasting to cell C3 will result in =B3+7 being input into
cell C3. Since the copy and paste operation moves the formula one
column (B to C) and two rows (1 to 3) the A1 relative cell reference
in the formula is moved one column and two rows to B3. If the result
of a copy and paste operation causes a relative cell reference name to
change to something that is outside the range of the spreadsheet cells, the
applicable column letter and/or row number will be replaced by a question
mark (?), and "ERROR" will be displayed as the cell’s data.
Absolute cell reference
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 no matter where you paste
them, you need to create an absolute cell reference name. To create
an absolute cell reference, put a dollar sign ( ) in front of the column
name and/or row number. You can use one of three different absolute cell
references: absolute column with relative row ( A1), relative column with
absolute row (A 1), or absolute row and column ( A 1).
To input the absolute cell reference symbol (
)
While inputting a formula into a cell, press
and then select
[Spreadsheet] > [ ].
To cut and paste spreadsheet data
1. Move the cursor to the cell whose data you want to cut.
2. Press , select [Cut & Paste], and then press .
• This enters paste standby. To cancel paste standby, press or .
3. Move the cursor to the cell into which you want to paste the data you
just cut, and then press
.
• Pasting data simultaneously deletes the data from the cell where you
performed the cut operation, and automatically cancels paste standby.
Note
• In the case of a cut and paste operation, cell references do not change when pasted,
regardless of whether they are relative or absolute.
To copy and paste spreadsheet data
1. Move the cursor to the cell whose data you want to copy.
2. Press
, select [Copy & Paste], and then press .
•
This enters paste standby. To cancel paste standby, press or .
91
Loading ...
Loading ...
Loading ...