Pasting Values with Formulas???
You guys will probably figure this problem out right away, but I can't seem to get excel to paste a number without changing the formula.
For example in cell C16 I have =average(B3:B6) the value is 4.2 when I copy the cell, click on E16 and paste, the formula changes to =average(D3:D6) and of course the value also changes (to 8.5)
I've tried "paste special" but I can't find an option that will work.
Can't I paste a value without the formula changing???
Are you trying to paste values
use pastexpecial > values
or
are you trying paste formulas so that the formula does not change
You need to change your formula by adding $ symbols in front of the part that you do not want to change
Have a look at
http://www.cpearson.com/excel/relative.htm
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Thanks a lot that worked great!!! I was hoping there was an easier way to do it but I just went through and added $ in all the formulas and it worked just fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks