Share via

Paste-Transpose option is missing?

Anonymous
2017-11-22T19:56:42+00:00

I'm working in Excel 2016 and am trying to Paste-Transpose numbers from a row from one workbook into a column in another workbook.  The workbook I'm pasting to does not have the option to transpose when I click the paste drop down.  Oddly enough, I do have the option in other workbooks I have open.  Anyone have any idea why that might be?

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-11-22T21:04:49+00:00

    Hi Jessica,

    We need additional details to address your concern about using the Transpose option. Kindly answer the following:

    • Which Windows build and version are you using?
    • How are you accessing the file, using a browser (Excel Online) or using the Excel desktop app?
    • If it is the Excel desktop app, which version is it?
    • Can you send us a screenshot of what you’re seeing when you click Paste or if you right-click the mouse after copying the data?
    • Is it a shared file?
    • Did you make any changes before this issue happened?
    • What troubleshooting steps have you done so far?

    We will be waiting for your response.

    Was this answer helpful?

    0 comments