This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
A coworker and I have been working on the same workbook, but copied and saved in different places. After filling in hundreds of rows, I needed to copy my work into her workbook. When I tried to copy and past these cells from mine to hers (both opened on my computer), a lot of cells are skipped. I have googled and searched through tips and forums to figure this out and no matter what method I attempt to do this, it will not work. I even selected only 4 cells (without empty rows in between) and it still would only paste 2 random cells from what was selected.
I know I can copy and paste numerous cells from one workbook to another because I have done this before. Never have I had a problem with excel.
The data I am working with are email addresses. I tried using all hyperlinked and non-hyperlinked.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Make sure that you remove any filters that you have applied, from both of the workbooks. And unhide all rows, if any were hidden.