Trying to Copy from sheet all values to another sheet

Closed
Harvinder - 31 Oct 2015 à 04:19
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 2 Nov 2015 à 11:10
Hello,
I am trying to Copy from sheet's all values to another sheet. But its not coping with their cells formate.

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
2 Nov 2015 à 11:10
Hi Harvinder,

Did you use a pastespecial > Values?

Then format isn't copied over.

You could a use "normal" paste first for the format and then use pastespecial > values for the values.

or vice versa.

Best regards,
Trowa