copying cell forumulas between page breaks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hnking@comcast.net - 31 Jan 2007 13:40 GMT

I am using excell11.3.3 on a mac computer ox 10.4.8
In a workbook, I am unable to copy a cell with a formula in it into a
cell on the next page of a worksheet. I have followed the
conventional cut and paste techniques to no avail. Please advise.
Thanks. HNK

Reply to this Message

jpdphd - 31 Jan 2007 15:17 GMT

On Jan 31, 8:40 am, hnk...@comcast.net wrote:

> I am using excell11.3.3 on a mac computer ox 10.4.8
> In a workbook, I am unable to copy a cell with a formula in it into a
> cell on the next page of a worksheet. I have followed the
> conventional cut and paste techniques to no avail. Please advise.
> Thanks. HNK

HNK,

Very strange!

One thing that occurs to me, are you using the sequence:
Copy
Insert > Page Break
Paste

If so, that could be the problem. If you copy a cell with a formula,
then do some other menu command, the copy buffer will be replaced by
the VALUE of the formula rather than the formula itself. When you
paste, you get the value, not the formula.

jpdphd

Reply to this Message

Bob Greenblatt - 31 Jan 2007 16:03 GMT

On 1/31/07 8:40 AM, in article
1170250829.541373.326570@a34g2000cwb.googlegroups.com, "hnking@comcast.net"

Can you provide some more detail? Does the copy work - do you see the moving
marquee on the copied cells? Do you get an error when you try to paste? What
is the error? What happens? What does "unable to copy..." mean?

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / January 2007

copying cell forumulas between page breaks