If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
copying a formula
You can use the shortcut (working in all versions) to toggle the view
Ctrl+ ` Or use Office ButtonExcel options..Advanced See display options for this sheet -kc *Click YES if this helps "STS" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|