View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
tomprochaska tomprochaska is offline
external usenet poster
 
Posts: 4
Default Losing cell content when copying and pasting

IF I select D1:IV1, and paste on D2 through D9, the content in the range
A15:C19 go blank. This occurs with "Panes frozen" but it doesn't matter
whether I am copying and pasting "across" the "freeze line"or not. IfI
"unfreeze Panes", I don't have this problem. I just wwitched from Excel 2003
to 2007, and never had this problem with 2003.


"Sheeloo" wrote:

What do you mean by 'not involved'?

If you select, say, 12 cells (3 rows and 4 cols) and paste it on D1 then
cells in the range D1:G3 will be overwritten with the source cells...

Also if formulae are involved then you may see unintended (by you) impact...

"tomprochaska" wrote:

When I copy multiple cells, and then do a paste, the contents of some cells
not involved with the copy and paste action are lost. Any ideas?