Loading ...
Loading ...
Loading ...
where the formula is located. If the formula =A1+7 is originally located in
cell B1, for example, 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) causes the A1
relative cell reference in the formula to change 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 (A1), or absolute row and column (A1).
To input the absolute cell reference symbol (
)
While inputting a formula into a cell, press ().
To cut and paste spreadsheet data
1. Move the cursor to the cell whose data you want to cut and then press
(Cut & Paste).
• This enters paste standby. To cancel paste standby, press .
2. 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 and then press
(Copy & Paste).
• This enters paste standby. To cancel paste standby, press .
2. Move the cursor to the cell into which you want to paste the data you
just copied, and then press .
• Paste standby remains enabled until you press , so you can paste
the copied data to other cells, if you want.
Note: When you copy the contents of a cell that contains a formula with a
relative reference, the relative reference will change in accordance with the
location of the cell where the contents are pasted.
To delete input data from a specic cell
Move the cell cursor to the cell whose contents you want to delete and then
press .
To delete the contents of all the cells in a spreadsheet
Press (Delete All).
Using Variables (A, B, C, D, E, F, M, [, \)
You can use to assign the value of a cell to a variable. You can also use
(RECALL) to input the value assigned to a variable into a cell.
22
スクリプト.indd22 2017/06/1217:18:30
Loading ...
Loading ...
Loading ...