16

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!

Dims
  • 12,244
  • 78
  • 161
  • 252
  • What options do you get if you press the key after pasting? Are any of them to paste as values/rows rather than nested? – Mokubai May 09 '18 at 16:49

8 Answers8

5

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.

Anthony Miller
  • 1,594
  • 4
  • 16
  • 23
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.

George Brown
  • 39
  • 1
1

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)

CortexCompiler
  • 1,645
  • 2
  • 10
  • 5
  • I can confirm a similar behaviour with OneNote 16 on Windows 10. I used Excel as a copy/paste vehicle. First, I copied my data in to an Excel Spreadsheet. Second, I added rows in the OneNote table. Then I copied the data from the Excel Spreadsheet and use the same number of columns as in the target OneNote table. Then, I place the cursor in the first cell of the new blank row in the OneNote table and pasted the data from the clipboard. – MichaelHuelsen Jun 28 '21 at 10:27
1

Right click the OneNote table and select "Convert to Excel", table in the OneNote will be converted and opened in the new Excel sheet (when you select Edit button).

ZygD
  • 2,459
  • 12
  • 26
  • 43
Shanmugaraj Selvaraj
  • 11
  • 1
1

Right click the OneNote table and select "Convert to Excel", table in the OneNote will be converted and opened in the new Excel sheet (when you select Edit button).

Shan
  • 111
  • 2
1

I just figured out how to do that. Using the instructions below, you can copy data from excel, word, one note etc. and it will work just fine and will not paste as a nested table inside the OneNote table.

Please follow the steps below:

  1. Check the number of columns in your OneNote table (say N)
  2. Select the cells in the table you want to copy into the OneNote table. If the table from where data has to be copied has N columns then fine else expand the selection to N columns. e.g. if the one note table has 4 columns and the table from where you want to copy has just 3 columns - you need to copy an additional column (i.e. 4) to match the number of columns in the One Note table
  3. Copy selection / Ctrl + C
  4. Go to one note table and select the entire row (all columns) at the bottom of the table. Only 1 full row needs to be copied irrespective of the number of rows you want to copy.
  5. Paste data / Ctrl + V
  6. You will see additional rows created in the OneNote table and all the data will be populated as per the columns in the table from where the data was copied.

Hope that helps!

Naveesh Goyal
  • 11
  • 1
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.

Meow_ly
  • 321
  • 2
  • 13
Greg
  • 1
-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.

Zoso
  • 171
  • 1
  • 9