There is a way, it needs some practice


- Select the range

- Move the mouse to the upper limit of the selection, the arrow becomes a cross
- While keeping the right mouse button down, you can move the range around
- Move it to where you need it ( it can be the same place as long as you moved the range around a bit)
- Release the mouse button
-From the menu that pops up select " copy here as values only"


Does that help ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi, Tried that just dont get to see a cross at all.


also tried edit cut then click in top left of selection expecting to see paste values with source formatting but alas that option isnt there.



DBenz