Discontiguous cell copy/paste

vwkess · Apr 18th, 2002, 06:16 AM

I haven't been able to find this answer anywhere on the net (so far anyway) or even in the MS knowledge base. The questions is:
I select discontiguous cells in a row or column, copy, then paste. Works fine if I'm pasting back into Excel. But if I paste it into Word, all the cells in between are also pasted; not just the selected cells. This happens in Office 97, 2k and XP.
So is this a limitation of Excel? Or is there a setting or add-in that can change this behavoir? TIA.

Anne Troy · Apr 18th, 2002, 06:39 AM

To the best of my knowledge: Yes, this is a limitation of Excel/Office. Because the other programs do not have the same format, they do not recognize the *in between* blank areas.

vwkess · Apr 18th, 2002, 07:55 AM

Thanks for the reply!

Apr 18th, 2002, 06:39 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	To the best of my knowledge: Yes, this is a limitation of Excel/Office. Because the other programs do not have the same format, they do not recognize the in between blank areas. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 06:16 AM	#1
vwkess New Member Join Date: Apr 2002 Posts: 2	I haven't been able to find this answer anywhere on the net (so far anyway) or even in the MS knowledge base. The questions is: I select discontiguous cells in a row or column, copy, then paste. Works fine if I'm pasting back into Excel. But if I paste it into Word, all the cells in between are also pasted; not just the selected cells. This happens in Office 97, 2k and XP. So is this a limitation of Excel? Or is there a setting or add-in that can change this behavoir? TIA.

Apr 18th, 2002, 07:55 AM	#3
vwkess New Member Join Date: Apr 2002 Posts: 2	Thanks for the reply!