6

If I select and copy part of the table and then select another part of the same size, then I get nested table

enter image description here

How to avoid this? I want cells to paste 1:1!

  • What options do you get if you press the <Ctrl> key after pasting? Are any of them to paste as values/rows rather than nested? – Mokubai May 9 '18 at 16:49
3

I have the same problem. My workaround is to copy and past into Word. Then paste the cells in the appropriate cells. OneNote is quite table friendly but I find it more efficient to manipulate tables in Word or Excel.

| improve this answer | |
2

So a couple of caveats:

  1. This will only work in the OneNote desktop app (will not work in O365/webapp).
  2. The amount of column cells from source must match the amount of column cells that exist in the destination.

With that said, if you're wanting to only copy a few cells out of the total, and both the source and destination tables have the same amount of columns, just copy all data from said columns and delete whichever cells of data are not necessary in the destination table. The data can be pasted either right below the table (and it will append itself to the bottom of the table) or in the first column of an empty row. At least in OneNote, you can click-drag vertically without it grabbing the entire row below/above so it doesn't generate a ton of clean-up work for you.

Apologies that this isn't a straight-forward approach, but it seems to be the only one that exists at the moment.

| improve this answer | |
0

Some terminology is getting mixed up in the previous answers. To have one or more columns copied or pasted from another table and appended to the right of an existing table without becoming nested, both tables must have the same number of rows.

I needed to copy two columns from one table to another. Both were basically the same and kept nesting until I realized the target table had an additional row that the old table didn't. Removing that extra row allowed everything to work properly.

| improve this answer | |
0

This is all about matching the number of rows or columns. For rows I find that if you match the number of columns then paste into a cell in the left most column of the destination it will insert the pasted row above your cursor.

Similarly for columns the destination table must have the same number of columns, and I have found you need to have the cursor in the bottom row. This will insert or append the pasted column(s) to the right. (Note: I did find it would not do it for me if I was adding one column to a single column table).

(this is in OneNote 16.41 on mac)

| improve this answer | |
-1

I have realised that this goes awry when the source and destination tables don't have the exact same number of columns. Thus I just copied the appropriate number of cells from the source table and pasting it works.

| improve this answer | |
  • 2
    doesn't work for me one note 2016 - onenote is both great and sucks at the same time – Mikey Mar 21 '19 at 7:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.