Inserting long Excel table into OneNote

Question

I embedded an excel spreadsheet on a page in one of my onenote notebooks, and I have it set to show only the table from the spreadsheet. Tt generally works fine (very slow, but fine), except for that it only shows the top part of the table. The table has 49 rows, but onenote only shows 23 of them. It has a little dotted line at the bottom like it knows it's cutting it off, but I can't figure out how to tell it not to cut it off like that. Is there just some maximum length for an excel table in onenote? 

I've attached an image of the top and bottom of the table in onenote. Thanks for any thoughts!

Answer 1

This is by design.

More over you will not be able to edit it directly in Onenote.

Answer 2

Highlight all required cells and use Copy & Paste (Ctrl-C & Ctrl-V) from Excel 2016 to OneNote 2016

Creates a table in OneNote that is searchable and resizable as needed.

Worked best for me

Answer 3

I had the same issue. A way round this is to use the print to onenote feature in excel. Set the print area as the entire row and column you want to display in onenote; for the print option use "fit all columns on one page" and use paper size A3. This will then display all the table in one note.

If you change anything in the excel document, you will have to run the print to onenote action again.

Its a temporary fix.

Answer 4

Also think this is foolish. At least there should be an option to display full length. I don't edit excel sheet in OneNote, but I don't want to open Excel every time I want to view the sheet.

If already display content, why not display full one? Then why we bother display content.

Please consider this feature of displaying full length for excel sheet, it will be very useful for a lot of users.

Answer 5

OK, thanks. Any idea why such a stupid thing would be built in?