Hi peeps,
This problem seems to pop up every now and again and i can't seem to quite figure out why. I've done a fair bit of searching on the net too with not much success, actually no success.
I have an excel report which is formatted a certain way (merged cells, font sizes, numbers, highlighting, etc) and when i paste the data into another excel spreadsheet it loses its formatting completely. I've tried all the paste options (paste special values, paste formats, paste column widths the works). Even if i select the format painter tool on a cell in the source file and apply format to a cell in the destination sheet it doesnt take effect.
Strange thing is, this only happens when pasting into certain excel documents. If i paste the source data into a newly opened excel spreadsheet it works perfectly with a simple "Ctrl C" and "Ctrl V"
Anyone else had this issue? Its driving me mad!
Bookmarks