Whether that window or the one you are expecting appears is determined by the source which has been copied. Without seeing that data it's difficult to speculate on why this is the dialog being displayed. A screen shot of the data may be helpful, but a link to a shared copy of a workbook illustrating the behavior would be better. It also would be appreciated if you'd specify your version level of Office 2016 as well as your version of OS X. Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J. Quicken essential for mac manual.

When you use Microsoft Excel on your Mac for creating spreadsheets, you have plenty of layout options. But, sometimes it’s not until after you start entering your data that you wish you had structured the spreadsheet differently. Then, click the Transpose checkbox when you finish and hit OK. When you complete the steps above, your columns. But now we need to “Transpose” the data into rows. Transpose the data (pivot the data - instead of getting split into columns, it gets split into rows) Highlight all our data and then click copy (or CTRL + C as a keyboard shortcut!).