Forum Discussion
Winnstan58
Nov 03, 2019Copper Contributor
new version of Excel will not allow me to copy the contents of multiple cells and paste them into
With the new version of Excel, I can no longer copy the contents of multiple cells at one time and paste them into a comment on another excel worksheet. This has really slowed down my work productio...
mathetes
Nov 04, 2019Silver Contributor
Winnstan58 Could you explain what the underlying purpose or goal is here. I ask because it sounds like what you're doing is an ineffecient or less than ideal way to use Excel in the first place....so if you could explain the purpose--maybe a bit about what the workbook is about, what this "copy and paste" procedure is meant to do--some of us could help.
On the surface, it sounds as if you're trying to keep a record of what values (the contents of the cells being copied) were at one time. If that IS the case, there are other far more effective ways to keep historical records in Excel. But that was just a guess. Your description would go a long way toward enabling some of us to offer suggestions or help.
Stew2807
Sep 28, 2021Copper Contributor
No, I believe he's trying to do what he used to be able to do which is copy information from one cell to another or to several others. We've lost that functionality and the ability to copy a formula and apply it to all the cells underneath! This is nuts! No one seems to have a fix here!