Pasting Formulas

  • Thread starter Thread starter Help
  • Start date Start date
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
 
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

Back
Top