How about edit > paste special OR Shift+Ctrl+V /paul
On 5/12/05, 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]
