How do you copy a formula to other cells without changing the for.

G

Guest

COPY A FORMULA TO OTHER CELLS WITHOUT CHANGING

ANYTHING IN THE FORMULA, I.E.(B12/C12). WHEN I COPY IT TO OTHER

CELLS IN A WORK SHEET, OF COURSE IT CHANGES TO (C12/C12, D12/C12, ETC)
 
G

Govind

Hi,

Press F2 ( cell edit mode) and then copy the contents of the cell and
paste it wherever you want.

Or else use = $B$12/$C$12 so that the reference is absolute and doesnt
change.


Regards

Govind.
 
G

Guest

Hi Suzanne,
you are using relative references. To make them absolute put a $ in front
of each part of the reference you want to be absolute ie ($B$12/$C/$12)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
SUM / COUNT formula 3
Is this formula the problem? 7
Help with formula 1
#DIV/0! 1
Help with SUMIF & AND function 2
Copying Functions 1
What is the problem with this formula? 5

Top