Thanks for help.

However I think that is not going to work for me, since I need to copy
paste a lot from different sheets and stuff :-/

Pete_UK kirjoitti:

> It is quite easy to define a macro to do this for you. Highlight a
> range, then turn the macro recorder on (Tools | Macro | Record new
> macro) and define a keyboard shortcut, eg CTRL-SHIFT-P - you might also
> like to locate the macro in personal.xls using the pull-down. While the
> macro recorder is running, click <copy> then Edit | Paste Special |
> Values (check) then OK followed by <Esc>. Then click <close> on the
> macro recorder icon.
>
> In future, all you will need to do is highlight your range and do
> CTRL-SHIFT-P to fix the values.
>
> Hope this helps.
>
> Pete
>
> Sirritys wrote:
> > or can I define one ?
> >
> > I'm really using a lot of paste values, and it's pain in the *** to use
> > right click menu every time
> >
> > Regards,
> > Sirritys