Hi community,

I am working on an Excel sheet in OneNote 2013 (Insert -> Spreadsheet).

OneNote embeds and shows the Workbook properly, except that some extra columns are visible on the right, which are empty and I don't want to see them.

I have tried to resize the area, however it actually resizes the container of Excel workbook, distorting the font size and making it hard to read.

Is there any way to set/limit the number of Excel workbook columns OneNote displays?

Thanks in advance.

Hi,

Based on my research and test, it seems that it is by design in OneNote 2013.

And there is no option to change the display range.

I have found a way to hide the extra columns that OneNote displays when an Excel document is embedded. All you have to do is hide all columns to the right of what you want to be displayed.  For instance, If I only want columns A-D to be displayed in OneNote, I need to hide columns E-XFD (This is for Excel 2013 which allows a maximum of 16,384 columns. For versions of excel before 2007 the last column is IV).

The easiest way to hide all columns:

1. Select the first column you want to hide by clicking on its header.

2. Press END to enter end mode.

3. Hold SHIFT and press RIGHT-ARROW. Release SHIFT.

4. Right-Click any of the selected cells and select Hide.

You can do the same with rows below what you want displayed, although I have never had a problem with OneNote displaying empty rows.

• Proposed as answer by BunchOfSage Tuesday, April 01, 2014 4:05 PM
• Marked as answer by Omid Shojaee Tuesday, November 18, 2014 2:30 PM

Thanks, this worked great.

I have a similar problem as I use a fair number of embedded spreadsheets to track a lot of information.  Sometimes there are a lot of extra columns off to the right hand side whether I want or need them. 

The other problem I am having is that when I save my spreadsheet, OneNote resizes the embedded view to be several times larger than the original.  This resize is not based on the zoom level, and the only way to fix this is to right-click on the "Edit" of the spreadsheet and tell it "Restore to Original size".  The odd thing is, it doesn't do this to every spreadsheet, only some of them.

Is there any way to keep it from resizing my spreadsheet randomly when I save it?  I know I am not telling it to resize anything, it just happens whenever it feels like it.

This seems like a bug that should have been fixed a long time ago.