Sometime in the last few months the copy/paste function within Excel (Office 365 version) stopped working for me. I have updated Windows and all Office apps to the latest version but that hasn't fixed the problem. I've also run the Office 365 The symptom is very strange. When I hit Ctrl-C (or use the drop-down menus) on a cell in Excel the dashed lines that surround a cell selected for copying show up very briefly but immediately disappear. If I go to another cell and paste it just puts a open parenthesis '(' in the cell. Using copy and paste is a routine part of most peoples Mac workflow, so if suddenly the Copy and Paste feature stops working or the clipboard appears These tricks work the same on all versions of macOS and Mac OS X, they work by targeting the clipboard daemon and forcing it to relaunch. •Paste Special -- You'll then see the Import and Paste Special dialog, where you can choose whether to filter and rearrange the data (such as Those features only work on Windows. Pasting an Excel table as a picture. You can copy a portion of an Excel spreadsheet and paste it onto a Prism graph. Using Ctrl-X to cut exhibits similar behavior. If I repeatedly hit Ctrl-C it will occasionally work (the dashed lines remain and I can paste) but it typically takes 15-20 tries before it will work and if I try again it will fail. This only seems to affect me when I try to copy cells. If I select a cell and then edit the cell and manually select the content of the cell I can copy and paste with no issue. It also appears to only be an issue when a cell is not empty. If I select an empty cell I can copy/paste just fine. If I select a cell that has been highlighted but has no content that also works properly. It's only when there's text or a formula in the cell that this is an issue. This only affects Excel, I haven't observed the issue in any other app. I had a similar issue, I copied a selection of rows to the clipboard, then tried to paste in a single cell below where I copied from and got the error 'You can't paste here because the copy area and paste area aren't the same size. Select just one cell in the paste area or an area that's the same size, and try pasting again.' It turned out that I wasn't scrolled all the way over, so column A wasn't showing and I was trying to paste the selection starting with column B at the row of the currently highlighted cell. I just needed to scroll over horizontally select the cell in column A, and press Enter or Ctrl-V to paste. I have had the same problem, complicated by the 'excel not responding' issue. In an effort to solve that problem, I changed some settings under options. Well, then my large workbook quit behaving nice. I would copy a row to one or more rows and all I got was the results from the copy reappearing in the new rows. Well, that was cured with switching the calculations from manual to automatic. Fixed the copy paste problem! Did I feel dumb? I faintly remember using the manual calculation on a large worksheet from 20 years ago. Now onto the 'excel not responding' issue. I've been trying to dump tons of formatting (color, borders, etc.) and checking for those stray columns/rows that had accidental formatting. I saw that in one of my searches on google. It seems to help, except in the process, the message comes up again and sometimes doesn't clear for hours, even overnight. It's hard to dump formatting if you can't access the file and save your changes. I have been dealing with recovered files, multiple saves and so on. I may have to start over with these files and recreate them. They are great grade calculators, with a sheet for each area (homework, attendance, quizzes, etc.) and pull into a summary page for final results. Lots of 'vlookup' action between sheets. The fancy formatting with colors, borders, boxes helped to avoid errors with data entry. I teach large classes (100+) and this has evolved with each graduate assistant, computer, software change over the past 15 years. Probably quite a patchwork job by now. I might be on the road to sanity if all of this works. Pc mac cross platform games for couples. I hope the manual to automatic switch in calculations works for you. This problem is just because you have 2 instances of EXCEL.EXE and you want to copy paste from one instance to another. You can't copy paste values for example. You can see that from your Start Task Manager. ![]() In excel 2010 any workbook opened from explorer was opened from the last application opened. In 365 they try but from my experience sometimes fails to open all of them in only one application. A solution is to open that excel file using File->Open commands inside your application and not double-clicking an excel file from explorer. I hope this helps. No, it's one seamless mouse operation. I position the mouse on the bottom right corner of the top cell to be selected then move the mouse down to select the required cells, At the bottom cell I move the mouse over to the adjacent column and it should copy the old contents into the new column. Now it copies the contents of the top cell into all the lower cells and doesn't attempt to copy them into the adjacent column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |