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

Send Selected Excel Rows to OneNote, Generating Multiple Corresponding Pages to Take Notes

2020-10-04 08:24
 
Row to OneNote is primarily about software that have rows in Office such as Access, Excel, Project that have some rows want to take notes with OneNote.
 

Select Multiple Rows, Send to OneNote into Multiple Pages

  1. At first, select multiple rows in Excel
  2. Then, click "View" tab ->Row to OneNote
 
In "OneNote Page Elements" window
  1. In "Header Row" box, input the row number. In this example, the header row number is 3. So, input the 3.
  2. For the title of the OneNote page, you can choose elements. Then, "Row to OneNote" generate the page title for OneNote with the elements.
The options offered are:
  • Excel sheet name: Customer Contact Details
  • Row number of header: 3
  • Cell A Content of Header Row: Customer ID
  • Cell B Content of Header Row: Company Name
  • Cell C Content of Header Row: Contact Name
  • Cell D Content of Header Row: Billing Address 


Select Multiple Rows, Send to OneNote into Multiple Pages


Build Multiple Corresponding OneNote Pages to Take Notes for Individual Excel Rows

 
"Row to OneNote" creates a new OneNote page for each selected rows, and then combines the header and the contents of the row into a table, and sent to this OneNote page.
At the same time, the OneNote page comes with a link "Link to Excel Row", which allows you to jump directly from OneNote to the corresponding Excel row (if Excel doesn't open, the workbook opens automatically). This makes it easy to take notes for a row of Excel.



Build Multiple Corresponding OneNote Pages to Take Notes for Individual Excel Rows


Tip: If you want to jump to OneNote from Excel, select a excel row, then in drop down the "Row to OneNote" menu, click the "Create OneNote Page Link" menu item. It will create a link for this row with current OneNote page.
This enables Excel that can jump to OneNote from Excel. The implementation uses OneNote to take notes for Excel.
 

 Demonstration



Send the selected multiple rows from Excel to OneNote and generate multiple corresponding OneNote pages to take notes for the rows that correspond to Excel.


 
Download Row to OneNote

Related Documents

  • Row to OneNote for Microsoft Excel
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.