modifying formula reference

R

referrrrrr

Hi, please help with the following:

I have formula that refers to one cell (lets say A5=B3). When i copy formula
from A5 to A6 (down verticaly), A6 refers to B4 (reference shifts down too).

What should I do to make reference to shift horizontaly? (after copying
formula verticaly to A6, reference should shift horizontaly to C3, not
verticaly to B4) Is this possible and how?
 

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