Share via

Copy/paste in excel on ipad

Anonymous
2017-12-26T15:09:52+00:00

how do you copy/paste from one execl spreadsheet to another excel spreadsheet? When i try to copy a column in which some cells have information and other cells that have no information, the pasted product collapses all the information poUtting all the cells which have information together.  Not pasted the same way they were copies. Any help out there with a workaround?

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-12-30T03:10:55+00:00

    Thank you, i have gone to and posted everything on the website you suggested. Is there any realistic chance that my problem will be corrected??  It might affect any further purchasevof an Apple product

    thanks

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2017-12-29T13:42:07+00:00

    Any chance that you can share this entire thread with Excel Uservoice so i do not have to go through all of our correspondence?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2017-12-29T08:35:09+00:00

    We've tried replicating what you're exactly doing with the Excel file. The same issue occurred when normally pasting the data on the spreadsheet. We also tried using the Paste Special option to paste the data and it successfully looks like it is on the right order. However, instead of the normal type of data, it is pasted as a picture. 

    There is a possibility that the way your device handles copied data from the clipboard eliminates the blank cells if you paste it on a different sheet. We highly suggest posting this concern on our Excel UserVoice. This is where we collect, manage, and act upon your feedback and suggestion for the betterment of our product and services.

    Let us know if you have other questions, and we'll be here to assist you.

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2017-12-28T13:55:40+00:00

    In the first screenshot i have copied the information from the first spreadsheet, column H rows 8 through 18.  In the second screenshot i have copied this information on another spreadsheet to DJ row 6.  As you see it has not copied exactly. It has compressed all of the numbers together eliminating the rows which containted no information as shown in the forst spreadsheet 

    thanks so much for looking into my problem

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2017-12-27T06:36:03+00:00

    Hi,

    We would appreciate if you could provide more details about your concern. Kindly answer following questions so we can isolate your concern:

    • How are you copying and pasting the information to another spreadsheet?
    • Can you send us a screenshot of the spreadsheet where the issue is happening? (Note: Make sure to hide/delete any important or private information you have on it.)

    In the meantime, kindly check this link and try the steps if it's different from the way you're copying and pasting the data

    We'll wait for your response.

    0 comments