Changing absolute references

  • Thread starter Thread starter bartmacl
  • Start date Start date
B

bartmacl

Hello, I am using Excell 2002. I am familiar with the $A$1 notation to
produce absolute references when copying cells. However, I want to be able
to copy a reference but have it increment in a way that I presently can't
figure out how to do.

For example, in the following cells, I have manually entered the following
references
B3 = 1/C2
B4 = 1/D2
B5 = 1/E2

when I copy B5 to B6, the reference becomes 1/E3. I want the reference for
B6 to be 1/F2.

Thanks

bmac
 
Back
Top