Menu
Although Microsoft Excel does not support copying and pasting multiple nonadjacent cells/cells/columns, but it allows users to copy and paste multiple non adjacent cells/rows/column in specified conditions. (1) Copy and paste multiple nonadjacent cells in the same column/rows 1. Holding the Ctrl key, and select multiple nonadjacent cells in the same column/rows one by one.
To paste the formula with its formatting, on the Home tab, click Paste or press + V. For other formula paste options, click the arrow below Paste. You have many options here, but the most commonly used ones are: Keep Source Formatting to paste the formula, the number formatting, font, font size, border, and shading of the original cell. When a cell reference from another sheet is required, simply click to select the required. Click and drag to copy the data OR double-click to autofill all rows. Use insert function (formula builder) to make VLOOKUP easier.
Press the Ctrl + C keys simultaneously to copy these nonadjacent cells; select the first cell of destination range, and press the Ctrl + V keys simultaneously to paste these nonadjacent cells. See below screenshots: (2) Copy and paste multiple non adjacent rows (or columns) which contain the same columns (or rows) 1.
Holding the Ctrl key, and select multiple nonadjacent rows (or columns) which contain the same columns (or rows). In our example we select multiple nonadjacent rows with same columns. See screenshot: 2. Press the Ctrl + C keys to copy these nonadjacent rows, next select the first cell of destination range, and press the Ctrl + V keys to paste these rows. See above screenshot: Copy and paste multiple non adjacent columns as below screenshot: Copy and paste multiple non adjacent cells/rows/columns with Kutools for Excel. Increase your productivity in 5 minutes.
Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful:. Merge Cell/Rows/Columns without Losing Data. Combine and Consolidate Multiple Sheets and Workbooks.
Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,. More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.
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 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. 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. The cursor displays a bold cross and doesn't change shape when selecting cells or trying to move the cells. It used to display a different cursor during this copy operation. Add me to the list. Some copy/paste function work,some do not. This started recently.
Specifically I was trying to copy formulas from a range of cells to paste into another range. Some cells had formulas, others only had values. When attempting to 'paste formulas', Excel would only perform a basic 'paste' of all the data in the copy-from range, thus overwriting the values in the target range. I tested with different files on three separate machines. One desktop and one tablet both running Office 365 desktop versions of Excel 2016, and one other desktop running Excel 2010. Same problem in all. Their are two common denominators: All three systems are running windows 10 (two running Pro, one running Home), and all the files tested were last modified using Excel 2016.
I've tried all the solutions posted here so far - no joy. I did the feedback to MS are requested. Surely hope this get a solution quickly. Productivity is being killed!! I was having the same issue as the original post, although after reading the thread I realized I had also lost the ability to drag down from two cells containing 1 and 2 respectively and have Excel complete a series: instead, all the cells in the range now had 1. Copy&paste didn't work in just one specific workbook, let's call it the 'failing workbook'. I had a few more open at the same time: copy/paste worked fine in all the others.
I could even copy in the failing workbook and paste correctly in another one. It was only in the failing workbook that if I selected a cell (or a range of cells), copied them, and as soon as I clicked on a new cell the dashed lines would disapear and there was nothing left to paste. Same as the original post, I was able to copy and paste the text content from one cell to another. I am an occasional Excel user: the only thing that was different between the failing workbook and the rest of them is that it contained macros. I don't fully understand the code, I copied it from a googled example and adapted it to my particular needs. The macros I copied count the number of coloured cells in a range.
While writing this reply I tried duplicating the file and removing the macro module on the copy. Copy&paste worked immediately after. After this I looked into the macros and saw that I had pasted the following code in the ThisWorkbook option: Option Explicit ' ' ' Private Sub WorkbookSheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) 'Uncomment the next line if you want to make Excel recalculate the ActiveSheet every time the Selection changes ActiveSheet.Calculate End Sub So I did comment back the ActiveSheet.Calculate line, and copy&paste worked once again!! Maybe for folks who are having the issue in any workbook, the problem could be triggered by having a start macro with some command such as the line I showed. The dragging issue must be another problem because it seemed to happen in all my workbooks, not only in the failing one. However after closing Excel and reopening just the failing workbook, dragging 1,2 to get a series was once again working, both in the failing workbook and in another fresh one I opened.
I could not get it to fail again. I hope this helps somebody at Microsoft look into both issues. I hope they can fix this but in the mean time this was my work around: 1. Make Clipboard visible under Home tab 2. Highlight what you would like to copy / paste and you will see it show up in clipboard 3. Select the cell where you want the info to be pasted on 4. Don't press Ctrl+V, instead press the actual item on the clipboard menu and the items will be pasted on the selected cell.
Note: it will be pasted without formats. Again if someone else can figure out this issue that would be great, but in the mean time these steps have worked every time. I had this very same problem. I tried to copy and paste from a word document onto excel but wouldn’t work. Right clicking also didnt work as the drop down only appeared for less than a second and disappeared again.
So I opened the clipboard and saw that i had 24 items of the same one in the clipboard. Tried to Clear All but to no avail. Anyway, i did this. I clicked on an empty cell.
And on the keyboard, i pressed Escape. And that fixed it. And i almost bought a new computer! Glad I didn’t! I've had similar issues in the desktop version of Microsoft Office Professional Plus 2010.
I first noticed that Excel would not drag-and-drop from cell to cell. I couldn't paste in, any capacity, within a workbook either. However, I could copy from Excel and Paste to another program(BluBeam/Adobe), just not another Office program.
Which lead me to discover the problem existed across all the Office programs I had open. I closed ALL Microsoft Office programs and re-opened them and the copy-paste functionality returned for all of them. I've just come across this issue in Excel on a colleague's computer, running Windows10. What we found as a workaround was that selecting the required range, holding Ctrl and dragging the entire frame from workbook A to workbook B successfully copied the range.
It helped that we were working on a dual screen. Normal copy & paste, using either Ctrl+C/Ctrl+V or right click did not work. As soon as we clicked on workbook B, the dotted lines from workbook A disappeared and the paste function reverted to pasting some text that had been copied elsewhere earlier in the day. Looks like this issue is going on since last October, with no resolution offered from Microsoft! I have the same problem. So far I was dealing with the annoying 'There is a problem with the Clipboard.'
Message - even if Excel 2016 was the only open program on my Windows 10 Pro PC at that time. Today, I find that even drag-and-drop copying is not working as expected. To be sure, the drag and drop works, but the selection and the cursor become non-responsive for several seconds.
The only way I can get them to respond seems to be either click on another Excel file, or click on the Preview in the taskbar to get back to the same file. The repair of Office programs did not work at all, and so far on my computer, this weird issue is restricted to Excel 2016 only (Version 1805; Build 9330.2087 Click-to-run). This did it for me, Im glad it was simple. Click on empty Cell and press ESC a few times and try again. Wrote: I had this very same problem. I tried to copy and paste from a word document onto excel but wouldn’t work. Right clicking also didnt work as the drop down only appeared for less than a second and disappeared again.
So I opened the clipboard and saw that i had 24 items of the same one in the clipboard. Tried to Clear All but to no avail. Anyway, i did this. I clicked on an empty cell. And on the keyboard, i pressed Escape. And that fixed it. And i almost bought a new computer!
Glad I didn’t! This worked for me. I had the copy and paste problem starting just recently. I open a blank excel file, type something in a cell, copy and then try to paste the cell elsewhere on the same sheet. After a few seconds excel is gone, closed down. I tried many of the solutions offered but nothing works.
I even uninstalled office and reinstalled it. Same problem. I was skeptical whether this would work but after opening a blank TextPad file, typing something in it, then selecting it and pasting it twice back in the same file, the excel file was able to copy and paste. Does this show the problem has something to do with the clipboard? Now when I try to duplicate it, it doesn't work any more.