PDA

View Full Version : Pasting into cell changes format - can this be stopped?



TLP
08-30-2013, 01:52 AM
Hi,

I wonder if anyone can help with this...

I have a spreadsheet where I copy and paste different information from different sources.

On one row/set of cells, when I paste something into it - it changes the format, so I am constantly having to go to the adjustcent cell and format paint into the other cell.

Is there a way to stop this from happening so that when I paste into the cell it keeps the right format or changes it to that format.

Cheers,

TLP.

BrianMH
08-30-2013, 03:29 AM
If you right click and paste special values it won't change the formatting.

TLP
08-30-2013, 03:36 AM
Can this be done using a keyboard short cut as I use Control + V to do this, I don't want to use a mouse touchpoint if poss.

BrianMH
08-30-2013, 04:07 AM
ALT+E,S,V

Ringhal
08-30-2013, 05:47 AM
This post may be your answer. http://excel.tips.net/T002657_Creating_a_Shortcut_for_Pasting_Values.html