9-15
When you are cut and paste a range cells, reference names that affect relationships within
the range are changed accordingly when the range is pasted in order to maintain the correct
relationship, regardless of whether they are relative or absolute reference names.
Cutting the B1:C1 range of cells that includes the formula =B1+5 and pasting it into B2:C2.
The formula pasted into C2 is changed to =B2+5 in order to maintain the relationship with
the cell to the left, which was also part of the pasted range.
u To cut and paste spreadsheet data
1. Select the cell(s) you want to cut.
• See “To select cells” (page 9-6) for more information.
2. Press 2(EDIT) 1(CUT).
• 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 cut, performing step below will cause
the exiting data to be overwritten with the pasted data.
4. Press 1(PASTE).
• This will paste the data from the cell(s) you selected in step 1 and paste it into the location
you selected in step 3.
• Regardless of whether Auto Calc is enabled or disabled (page 9-5), pasting cut data will
cause all of the formulas in the spreadsheet to be recalculated.
→→
To Next Page
Loading...
Need help?
General
