Copy / Pasting Formulas

wayne_turner69

New Member
Joined
Sep 19, 2006
Messages
1
I need to paste a formula with the same value in a collum. When I copy cell 1 and paste in 2 - 10 it increments the number.

ex

1. left(a1,2) (Original)

after paste

2. left(a2,2)
3. left(a3,2)

I need the value left(a1,2) in all cells.

Thanks for the help.
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Hi Wayne, welcome to the Board!

What you need is an absolute reference.
Change
=LEFT(A1,2)

To
=LEFT($A$1,2)

When you copy this formula down it will continue to reference A1.

Denis
 

Watch MrExcel Video

Forum statistics

Threads
1,113,845
Messages
5,544,629
Members
410,626
Latest member
rkmadasu
Top