Ok, I'm pretty new to excel and I've searched around for this, but can't seem to find the answer.
I want to know if there is any way to have excel change only one part of the formula when you fill. Such as:
=A1/B1
=A1/B2
=A1/B3...
When I use the fill function, it changes both parts of the formula, like this:
=A1/B1
=A2/B2
=A3/B3...
Any ideas?
Take a look at this link for an answer
http://www.cpearson.com/excel/relative.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
That's it. Thank you very much.Originally Posted by oldchippy
Glad to help - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks