Absolute reference formula not copying to cell in Excel 2007. How to do it?

Please look at attached. I put an absolute reference formula in A10,which I am trying to copy to A19. However, all I get in A19 is the value, not the formula, as evidenced by the formula bar. Please advise as to what I am doing incorrectly. Thanks in advance.AABB.png
sheana11Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

do you have Skype installed?

There is  currently an issue with Paste Special that causes formulas to be pasted as values instead of the formulas. The browser plug-in for skype upsets the "Paste Special" functionality and defaults to pasting values instead of formulas. You may want to remove the  browser plug-in for skype (no need to uninstall skype itself). See here for details: http://www.thecodecage.com/forumz/hot-topics/212321-paste-paste-special-issues-office.html

cheers, teylyn
0
 
AnuroopsunddConnect With a Mentor Commented:
Right click on the cell where you want to paste.. select paste special.. then say formula..
0
 
sheana11Author Commented:
Absolute formula is in F10, not A10, sorry!
0
 
sheana11Author Commented:
I actually forgot to put the $ sign in front of each row and column reference....I only put it in front of one of the cell coordinates.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.