• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

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
0
sheana11
Asked:
sheana11
  • 2
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)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
 
AnuroopsunddCommented:
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

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now