Excel copy & paste to Keynote Chart, data loses formatting

When I copy from Excel for Mac (version 16.11), and paste into Keynote (version 7.3.1), the formatting jumps every time. This means I have to paste individual cells one by one instead of the whole table of numbers, which is time consuming every time.

Eg 1:

Copy this from Excel:

Paste and get this in Keynote:

Eg 2:

Copy this:

Get this:

Posted on Mar 18, 2018 11:03 PM

Similar questions

Numbers does not export a chart to Keynote anymore - only jpg Dear all,I have been working making stacked 2D bar plots in numbers which I rework (to make complete figures for publishing) in Keynote. In the past I never had to wonder how to continue editing in Keynote since by copy/pasting the chart was copied with its data and series all together. Now since I started working on the same filed to do an update of data, I find that I can only import jpg in Keynote. If I do command-c and I look in finder in the clipboard, I in fact see an image. What can I do? I need to write a paper and I am already delayed enough!Best
1489 5
"How to" perform common Excel actions in Numbers chart? Does one exist? Hello, After upgrading to Big Sur ALL my Excel spreadsheets have gone bonkers (upside down, backwards and overlapping). Scrolling down and then back up usually fixes small spreadsheets but larger ones remain a mess. Thus biting the bullet and moving to numbers. However,I am having great difficulty discovering how to do many routine actions and keep having to do searches to determine how. For example "Fill Down" was a button in Excel, but I can only find it under the Table Menu->Autofill Cells->Fill Down which is fine now that I know it is there. Another example is trying to figure out how to freeze rows and columns. I know Numbers can do everything I generally need once I learn how. Does anyone know of a table or chart that provides comparative methods to accomplish such activities in Numbers and Excel? Thanks in advance for your assistance.
882 10
Formula editor in Keynote is not appearing I'm using Keynote 7.3.1 on a Mac running OS 10.13.3In a Keynote presentation I am preparing, I have several charts that display data in tables that I created using the "Edit Chart Data" table that is available whenever you create a chart.I want to use some simple functions (just addition and subtraction) to generate some of the data in the Chart Data table. Keynote Help says that when I enter an = sign in a cell, a formula editor will automatically open. But it isn't happening. Does anyone have any suggestions for why the formula editor isn't appearing?Thanks!
1386 4

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Excel copy & paste to Keynote Chart, data loses formatting

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up