Hi Bob, Once you uncheck 'paste all', the rest will be enable. tc
Bob Lockie wrote:
On 11/05/2005 9:47 PM Paul spoke:
You can highlight and copy the range then re-highlighting an equivalent area select paste special. In the additional dialog ensure that only 'numbers' is selected, then OK. The results of the formulas will then be pasted into the cells.
/paul
All the paste options are greyed out except for "Paste All". :-(
On 5/12/05, Bob Lockie <[EMAIL PROTECTED]> wrote:
I have a bunch of formulas that are just references to other parts of the spreadsheet and I have decided that instead of reference I actually want to copy the data. Is there an easy way to do this?
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
