copying a formula



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?




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

Ctrl+ `

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

*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