copying a formula

S

STS

I am unable to copy the formula of a cell to the clipboard and paste it in
another spreadsheet. The paste formula option is greyed out of the pulldown
menu, and the Paste Special does not display any options for pasting formulas
or formats. It appears as though the cell has been copied as an object or
value. The copy/paste function works fine on the same file when used on
someone else's workstation. Do I have a default option set incorrectly
somewhere on my computer?
 
K

KC

You can use the shortcut (working in all versions) to toggle the view

Ctrl+ `

Or
use Office Button>Excel options..Advanced
See display options for this sheet

-kc
*Click YES if this helps
 

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

Similar Threads

Copying functionality lost 1
Pasting a cell into bookmarked table from excel vba 1
Copying Formulas 2
Excel 2010 not allowing me to paste as formula 8
Copy unformatted value of cell via macro 0
Paste Special Values 2
Odd Formula copying Behavior 3
unable to copy cell reference 6

Top