ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Allow pasting as a value to several discontinuous cells at once. (https://www.excelbanter.com/excel-discussion-misc-queries/97971-allow-pasting-value-several-discontinuous-cells-once.html)

Harveywater

Allow pasting as a value to several discontinuous cells at once.
 
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/comm...lic.excel.misc

David Biddulph

Allow pasting as a value to several discontinuous cells at once.
 
"Harveywater" wrote in message
...
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.
--
David Biddulph




All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com