Discussions Search    Reviews    Search Aid    Buzzzz    Google@Omgili Add to iGoogle   Bookmark and Share

  Advanced Search



Difference between Cut and Paste....

On Thu, 3 Jul 2008 00:23:00 -0700, DanF <...@discussions.microsoft.com
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

 Latest discussions from this group  (microsoft.public.word.docmanagement)

How do I set a document so that each page is a fixed size.  
[27 Aug 2008]
On Wed, 27 Aug 2008 07:31:01 -0700, BLB <BLB@discussions. microsoft.com I am trying to...
set each page in Word to a fixed size meaning that I do not want text to wrap to the next...
word perfect merged documents  
[27 Aug 2008]
On Wed, 27 Aug 2008 08:36:01 -0700, Lorri <Lorri@discussion s.microsoft.com I use several...
documents every day with only minor changes, names mostly, - which i had set up as a ...
I need a plain language apartment lease  
[27 Aug 2008]
On Wed, 27 Aug 2008 14:45:00 -0700, RR <RR@discussions.m icrosoft.com
On Wed, 27 Aug 2008 16:47:41 -0500, "Tom [Pepper] Willett" <tom@youreadaisyi fyoudo.com...
More...


On Thu, 3 Jul 2008 00:48:00 -0700, Anup Tawde <...@microsoft.com
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

--
Regards,
Anup



> DanF

On Thu, 3 Jul 2008 00:56:09 -0700, DanF <...@discussions.microsoft.com
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!
;-)


> > DanF

On Wed, 9 Jul 2008 02:46:00 -0700, Stefan Blom <...@please.xyz


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







> > > DanF

Discussion Title: Difference between Cut and Paste....
Title Keywords: Difference  between  Paste.... 



Omgili Home Usenet About FAQ Plugins