Difference between Cut and Paste....

[DanF]

Morning all!

This may be an easy question to answer or not...
In Excel what's the difference between Cut and Paste?

The reason I ask is because I have a sheet where I get #REF! errors when the
users 'Cut' data between cells.

The sheet, I'll call sheet 1, is referenced by multiple other sheets in the
workbook (mostly formulas). It has its Headings (Columns/Rows) hidden, so the
users can't delete entire rows. Sheet 1 has no formulas in it.

When the users Copy data into Sheet 1 and move the data around using Copy,
all is well.
If the users move the same data around using Cut, I get #REF! errors in the
sheets that reference Sheet 1.

What is causing this?

Thanks for any and all replies
DanF

 

[Anup Tawde]

I think you are landed in wrong forum as your question is for excel and this
is word forum..!

neways,

Let's assume that you have data in Sheet1 and you have inserted formula in
Sheet2, in this case Sheet2 will only display the calculated value
(reference) of Sheet1. When you copy data from Sheet1, it works properly.
But, when you CUT that data from Sheet1, ultimately, you are (re)moving the
reference value of Sheet2. As a result, Sheet2 has nothing to display as the
reference from Sheet1 is missing

 

[DanF]

Ooooppsss! Clicked on the wrong favourite link!!

Thanks for replying, but it doesn't really make a lot of sense.

Surely the cell C6 (for instance) is always C6 - if you move the data
around, why does the formula try to follow it?

I would have thought that a formula should always reference the cell you
wish, unless you instruct it otherwise.

Oh well.

Better instruct the users not to use CUT!!

Thanks mate, I'll try to read the links before clickng on them next time!
;-)

 

[Stefan Blom]

Ooooppsss! Clicked on the wrong favourite link!!

Thanks for replying, but it doesn't really make a lot of sense.

Surely the cell C6 (for instance) is always C6 - if you move the data
around, why does the formula try to follow it?

I would have thought that a formula should always reference the cell you
wish, unless you instruct it otherwise.

By default, cell references in Excel are relative, unlike the cell
references used in Word table cells which are absolute. To force an absolute
reference in Excel, use $ with rows and/or columns. For example: $C$6 will
always refer to that cell, even if you copy or cut it.

--
Stefan Blom
Microsoft Word MVP