20050401
9-4-15
Inputting and Editing Cell Data
k
k
k
k
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 fx-9860G AU PLUS
Page 1: ...fx 9860G AU User s Guide E http edu casio com ...
Page 2: ...Important Please keep your manual and all information handy for future reference ...
Page 27: ...20050401 1 1 Keys 1 1 1 Keys ...
Page 335: ...20050401 u u u u u Input Example u u u u u Results 6 5 25 Tests ...
Page 361: ...20050401 Calculation Result Output Example p F distribution probability 6 7 15 Distribution ...
Page 435: ...20050401 8 8 2 Program Library egcw w ww w ...
Page 437: ...20050401 8 8 4 Program Library Example 1 Example 2 fw baw bf w fw baw ca w ...
Page 439: ...20050401 8 8 6 Program Library wba wb w w d ...
Page 441: ...20050401 8 8 8 Program Library dw fcde wfcde wfcde fcde w daw w 20070101 ...
Page 443: ...20050401 8 8 10 Program Library b awaw bwaw aw x d w ...
Page 590: ...CASIO COMPUTER CO LTD 6 2 Hon machi 1 chome Shibuya ku Tokyo 151 8543 Japan SA0701 E ...