Allow pasting as a value to several discontinuous cells at once.

[Guest]

In Excel, one should be able to paste the value of one cell into several
other discontinuous cells at one time rather than only being able to paste
them in continuous blocks. The error message concerning merged cells does
not apply since the cells aren't merged to begin with.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...7-eea3ae192dd7&dg=microsoft.public.excel.misc

 

[David Biddulph]

In Excel, one should be able to paste the value of one cell into several
other discontinuous cells at one time rather than only being able to paste
them in continuous blocks. The error message concerning merged cells does
not apply since the cells aren't merged to begin with.

Excel can. do that paste operation.

If you're getting an error message, I suggest you check your sheet again.