Nov 03 2019 10:20 AM
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 production. Is there a fix for this? It is driving me crazy.
Nov 03 2019 07:50 PM
@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.
Feb 09 2021 06:28 AM
I cant use the function outfill
ex
1
2
3
4
and then when I want to autofill it change all cells to No 1.
I´ve tried to right click but it only gives me functions I don´t need. When I compare with my work computer the possibility to auto fill comes up among a lot of other options. I have a NEW version on my own computer and my work computer has an old version of excel - and there auto fill works. HELP
Feb 09 2021 10:24 AM
Sep 28 2021 02:58 PM