20070201
9-4-15
Inputting and Editing Cell Data
k
Cut and Paste
You can use the procedures in this section to cut the data in one location of a spreadsheet
and paste in another location. You can cut the contents of a single cell or a range of cells.
u
How cut and paste affects cell references
The cut and paste operation has special rules that govern how cell references (page 9-4-5)
within the cells being cut and pasted are handled. There are actually two different sets of
rules to cover the following two conditions.
• When cells within the cut area are referencing cells that are outside the cut area
• When cells within the cut area are referencing cells that are also within the cut area
•
When a cell within the cut area is referencing a cell that is outside the cut area
In this case all cell references are treated as absolute cell references, no matter what
type they actually are (absolute or relative).
Example
Let’s say we have a spreadsheet that contains the following data:
A1: 4, B1: =A1+1, C1: =B1+2.
Cut B1:C1 (left screen) and paste the data in B2:C2 (right screen).
Since the expression in cell B1 references cell A1, which is outside the cut
area (B1:C1), the A1 reference is pasted unchanged (like an absolute cell
reference) into cell C2.
⇒
⇒
Summary of Contents for CFX-9850GB PLUS
Page 19: ...20070201 4 Contents Appendix 1 Error Message Table α 1 1 2 Input Ranges α 2 1 ...
Page 335: ...20070201 u Input Example u Results 6 5 25 Tests ...
Page 361: ...20070201 Calculation Result Output Example p F distribution probability 6 7 15 Distribution ...
Page 435: ...20070201 8 8 2 Program Library egcw w ww w ...
Page 437: ...20070201 8 8 4 Program Library Example 1 Example 2 fw fw baw baw bf ca w w ...
Page 439: ...20070201 8 8 6 Program Library d wba wb w w ...
Page 441: ...20070201 8 8 8 Program Library dw fcde fcde w wfcde daw wfcde w ...
Page 443: ...20070201 8 8 10 Program Library b awaw bwaw aw x d w ...
Page 591: ...20070201 Appendix 1 Error Message Table 2 Input Ranges α ...
