new version of Excel will not allow me to copy the contents of multiple cells and paste them into

%3CLINGO-SUB%20id%3D%22lingo-sub-976402%22%20slang%3D%22en-US%22%3Enew%20version%20of%20Excel%20will%20not%20allow%20me%20to%20copy%20the%20contents%20of%20multiple%20cells%20and%20paste%20them%20into%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-976402%22%20slang%3D%22en-US%22%3E%3CP%3EWith%20the%20new%20version%20of%20Excel%2C%20I%20can%20no%20longer%20copy%20the%20contents%20of%20multiple%20cells%20at%20one%20time%20and%20paste%20them%20into%20a%20comment%20on%20another%20excel%20worksheet.%26nbsp%3B%20This%20has%20really%20slowed%20down%20my%20work%20production.%26nbsp%3B%20Is%20there%20a%20fix%20for%20this%3F%26nbsp%3B%20It%20is%20driving%20me%20crazy.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-976402%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-977117%22%20slang%3D%22en-US%22%3ERe%3A%20new%20version%20of%20Excel%20will%20not%20allow%20me%20to%20copy%20the%20contents%20of%20multiple%20cells%20and%20paste%20them%20int%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-977117%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F439454%22%20target%3D%22_blank%22%3E%40Winnstan58%3C%2FA%3E%26nbsp%3B%26nbsp%3B%20Could%20you%20explain%20what%20the%20underlying%20purpose%20or%20goal%20is%20here.%20I%20ask%20because%20it%20sounds%20like%20what%20you're%20doing%20is%20an%20ineffecient%20or%20less%20than%20ideal%20way%20to%20use%20Excel%20in%20the%20first%20place....so%20if%20you%20could%20explain%20the%20purpose--maybe%20a%20bit%20about%20what%20the%20workbook%20is%20about%2C%20what%20this%20%22copy%20and%20paste%22%20procedure%20is%20meant%20to%20do--some%20of%20us%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20the%20surface%2C%20it%20sounds%20as%20if%20you're%20trying%20to%20keep%20a%20record%20of%20what%20values%20(the%20contents%20of%20the%20cells%20being%20copied)%20were%20at%20one%20time.%20If%20that%20IS%20the%20case%2C%20there%20are%20other%20far%20more%20effective%20ways%20to%20keep%20historical%20records%20in%20Excel.%20But%20that%20was%20just%20a%20guess.%20Your%20description%20would%20go%20a%20long%20way%20toward%20enabling%20some%20of%20us%20to%20offer%20suggestions%20or%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

4 Replies

@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.

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

 

You have tagged on to an old message thread with a new question. Somewhat related, but I'd like to recommend that you start an altogether new thread. And when you do, if you could attach a copy of the spreadsheet you're describing.... I for one don't even know what "the function outfill" is. Or was that a misprint, when you mean autofill?
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!