Is there any way to paste tabular data into an existing OneNote table.  Can't believe that this isn't possible yet I can't seem to make this work.

• Moved by George Hua Thursday, October 17, 2013 3:17 AM OneNote product issue

Hi,

Thank your for posting in MSDN forum.

Since this is a OneNote product issue, I have moved it on Office 2010 - IT Pro General Discussions forum for more effective responses.

Thank you for your understanding.

Hi,
What kind of tabular data did you try to paste?

Do you just want to copy some data that are in table format and paste it into the existing OneNote table?

Ive tried copying a tabular data from Excel and paste to OneNote, it will paste without issue. I have tested the copy/paste steps in OneNote 2007, OneNote 2010 and OneNote 2013, all of them will get this done.

If Ive misunderstood something, please provide more information about this issue.

Thanks,

Steve Fan
TechNet Community Support

"Is there any way to paste tabular data into an existing OneNote table.  Can't believe that this isn't possible yet I can't seem to make this work."

I realise that it is not possible to past tabular data from current OneNote table to Existing OneNote table. 

Please advise if there is any way to do it quickly. Thanks.

The result of pasting a table in Excel or Word 2013 into an existing onenote 2013 table is the table is pasted within a cell of the destination onenote table:

See the table is in the first cell (upper left) of the destination table. It was supposed to be merged with the destination table's first column

I've been experimenting with cutting and pasting tabular data from one OneNote table into another OneNote table. I can reproduce the behavior that you describe if the two tables have a different number of columns.

The problem can be solved by making sure that both tables have the same number of columns. So, if your source table only has one column with data, add empty columns to it.

Select the entire source table, including the empty columns. A quick way to do this is to repeatedly press Ctrl-A until the entire table is selected. Copy the table and then try to paste again into the target table.

I hope this helps.

• Proposed as answer by kyrrian 7 hours 53 minutes ago

Thank you for this last suggestion (copy paste from Excel to OneNote to create a seperate OneNote table, then make that new table match (number of columns) the existing OneNote table you want to paste into, then highlighting all columns (even blank ones) in source table, and copying into existing OneNote table.  Worked great!  Wish Microsoft could fix this though, but in the meantime, the workaround will be okay.

This helped me, too!

Thanks for updating the old thread.