MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy a cell intake


Posted by Tezza on February 08, 2002 4:08 PM

How do I copy a cell from one to the next, or even more importantly from one sheet to the next, without Excel trying to be clever and adding onto row numbers/column numbers/ sheet names! etc.

Tezza


Posted by Escalus on February 08, 2002 4:14 PM


There are a number of ways. Here's one :-

Highlight the formula in the formula bar
Copy
Press the down arrow
Select the destination cell
Paste

Posted by Tezza on February 08, 2002 5:00 PM

I tried it and I can follow you upto the 'Press the down arrow' Which arrow do you speak of sir. I tried various including the cursor down arrow, and still to no joy, I feel you speak in forked tongue sir,

Regards
Tezza, (Pleases speak plainly as I am an ignoramous!!!)

Posted by Escalus on February 08, 2002 7:15 PM

On your keyboard you have a key with an arrow on it that points downwards (or, if you like, points towards you).
Sorry, but cannot think of a way to describe it in words of one syllable only. I tried it and I can follow you upto the 'Press the down arrow' Which arrow do you speak of sir. I tried various including the cursor down arrow, and still to no joy, I feel you speak in forked tongue sir, Regards

Posted by Derek on February 09, 2002 7:15 AM

Tezza
If you wish to copy a formula exactly as it is, first delete the = sign and reinsert it after you've pasted.
Derek

How do I copy a cell from one to the next, or even more importantly from one sheet to the next, without Excel trying to be clever and adding onto row numbers/column numbers/ sheet names! etc.