Search
OneNoteGem
  • Home
  • Addins
    • Windows Office Addins >
      • Gem for OneNote
      • OneNote Search Bar
      • OneNote Gem - Favorites
      • OneNote Batch
      • Pons for MindManager and OneNote
      • Mind Map for OneNote
      • Pons for Visio and OneNote
      • Row to OneNote
      • Auto OneNote
      • Favorite to OneNote
      • Bridge for EndNote and OneNote
      • Anchor to OneNote
      • Anchor to OneNote for PDF
      • Bring to OneNote
      • Gem Table for OneNote
    • Windows UWP Addins >
      • Gem Menu for OneNote UWP
      • CiteBoard for OneNote
      • OneReader
      • OneMind for Windows OneNote
      • OneNote Reminder Cloud (UWP)
      • OneNote Batch Cloud (UWP)
    • Mac Addins >
      • Gem Menu for Mac OneNote
      • CiteBoard for OneNote
      • Bring to Mac OneNote
      • OneMind for Mac OneNote
      • OneNote Reminder for Mac
      • OneNote Batch for Mac
      • Fix One for Mac - Fix OneNote Login, Sync Tools
    • Android Addins >
      • CiteBoard for OneNote
      • Fix One for Android - Fix OneNote Login, Sync Tools
    • Cross-Platform Addins >
      • OneNote Reminder
      • OneMind for OneNote
      • CiteBoard for OneNote
      • Fix One - Fix OneNote Login, Sync Tools
    • Markdown Addins >
      • Gem for OneNote
      • One Markdown
    • Mind Map Addins >
      • OneNote Gem - Favorites
      • Pons for MindManager and OneNote
      • Mind Map for OneNote
      • Pons for Visio and OneNote
      • OneMind for OneNote
    • Other Addins >
      • One Markdown
      • Clip to OneNote
      • WordNote
      • OneShare
      • Fix One for Windows - Fix OneNote Login, Sync Tools
  • Buy
  • Documents
  • FAQs
  • Templates
  • Support
  • Release
  • WordNote
Gem Table for OneNote
 
 
The table of merged cells for OneNote

How to remove extra empty columns display in Excel spreadsheet in OneNote

2019-11-26 16:04
 
Extra Empty Columns Display in Spreadsheet in OneNote

OneNote can insert Excel spreadsheet from 2013 version.
But it has some extra empty columns display on the right of spreadsheet, they take up a lot of space on page.
Extra Empty Columns Display in Spreadsheet in OneNote
Extra Empty Columns Display in Spreadsheet in OneNote
How to remove these extra columns?

We can edit this spreadsheet by Excel to remove these extra columns.

Click "Edit" button on spreadsheet in OneNote, it will open this spreadsheet using Excel.

Edit Spreadsheet to Remove Empty Columns

To make these extra columns don't show on OneNote, we need to hide the empty columns in Excel.

Select all Empty Columns on Right Side

​1.  Select first empty columns.
2.  Press "End" key.
Select all Empty Columns on Right Side
Select all Empty Columns on Right Side
3. ​Press Shift + Right key
Select all Empty Columns on Right Side
Select all Empty Columns on Right Side
Hide all Empty Columns

Right click on selected empty columns, click "Hide" item on pop up menu. Excel hide the selected columns.
Hide all Empty Columns
Hide all Empty Columns
Extra Empty Columns Disappear

In Excel, click "Save" button to save the spreadsheet back to OneNote.

Return back to OneNote, we can see the extra empty columns have gone.
Extra Empty Columns Disappear
Extra Empty Columns Disappear

 
EXE Addins UWP Addins MAC Addins

Related Documents

  • How to View Version History of Word Document on OneDrive.com?
  • List the Website Can Embed Content (Include Documents, Videos, Audios) into OneNote
  • OneNote Linear Format Equations
  • How to Create and Customize Tag in OneNote?
  • How to enable text recognition in pictures in OneNote?
Command Line
Tag System
MindMap Add-Ins Comparison
Search Add-Ins Comparison
One Markdown Syntax
Table Formula
Gantt

Gem Menu Templates
Repair OneNote
OneNote Download
English website Chinese website
Mobile Site
Copyright © 2011-2025 Digital GemSoft. OneNoteGem.com All Rights Reserved.