Copying Cells Without Change.

[W. Watson]

I have a colum of cells that look like:
In column F
row 4: =c1
row 5: =c2
row 6: =c3

I want to copy them to row 10 of F. They end up as
row 10: =c10
row 11: =c11
row 12: =c12

I want them to be copies as =c1, =c2, =c3
How do I do that?

Wayne T. Watson (Watson Adventures, Prop., Nevada City, CA)
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet

Wayne T. Watson (Watson Adventures, Prop., Nevada City, CA)
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet
--

"I'm addicted to placebos. I'd give them up but,
it wouldn't make any difference." -- Steven Wright

Web Page: <home.earthlink.net/~mtnviews>

 

[Bob I]

Change the Cell reference to Absolute Addressing before copying them down.

$C$1
$C$2
$C$3