Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula not copying over as before | New Users to Excel | |||
Copying a formula | Excel Worksheet Functions | |||
copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
COPYING SUM/IF FORMULA | Excel Discussion (Misc queries) | |||
copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions |