Pasting Formulas

H

Help

I am using a fairly simple formula. I am subtracting one cell from another
and dividing by a third do an example would look like this (I2-V4)/V3. I
want to paste the entire column with this so that the next formula would be
(I3-V4)/V3, however it appears as (I3-V5)/V4). How do I stop it from
changing all values. I only want the one individual value changed (the "I"
column). There are almost 1000 rows so doing it individually seems ridiculous
 
M

Max

Do the dollar signs just represent an unchanging value?

Yes, it's the way to "fix" the col and/or row reference
 

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

Top