'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Link to a Specific OneNote Paragraph from Excel
Question details
The user wants to create a hyperlink in Excel that navigates directly to a specific paragraph in a OneNote notebook.
- Product
- Microsoft Excel, Microsoft OneNote
- Device & OS
- not provided
- Scenario
- Creating a hyperlink in an Excel spreadsheet to reference and jump to a specific section or paragraph within a local OneNote notebook.
- Observed behavior
- When pasting the copied OneNote link into Excel, it defaults to an HTTPS web link that opens the top of the OneNote page in a web browser, completely ignoring the specific paragraph selection.
Ensure you are using a desktop version of OneNote (such as OneNote 2016 or OneNote for Microsoft 365), as OneNote for the web and OneNote for Windows 10 do not support paragraph-level deep linking.
Extract and Use the Local Desktop Application Link
Extract the local 'onenote:' URI from the clipboard using a text editor to ensure Excel opens the specific paragraph in the desktop app.
When you copy a link to a paragraph in OneNote, the application places both a web link (https://) and a local client link (onenote:) on your clipboard. Office applications like Excel default to pasting the web link, which ignores the fragment identifier for the paragraph. To fix this, you must manually extract and use the local link.
Right-click the target paragraph in your OneNote desktop application and select 'Copy Link to Paragraph' from the context menu.
Open a plain text editor such as Notepad and paste the clipboard contents. You will see two separate addresses: one starting with 'https:' and another starting with 'onenote:'.
Highlight and copy only the address string that begins with 'onenote:'. Ensure you include the text following the fragment identifier (#) at the end of the link.
Open your Excel workbook, select the cell where you want the link to appear, and press Ctrl+K (or right-click and choose 'Link').
Paste the copied 'onenote:' URI into the Address field at the bottom of the Insert Hyperlink dialog box and click 'OK'.
Easily Manage Advanced Hyperlinks with WPS Spreadsheet
WPS Office offers a highly compatible and lightweight Spreadsheet application that fully supports custom URI protocols like 'onenote:'. You can easily organize your data and deep-link to external desktop applications using the same familiar workflow.
- 1. Open your document in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet or create a new one.
- 2. Open the Hyperlink menu: Select the target cell, navigate to the 'Insert' tab on the top ribbon, and click 'Hyperlink' (or use the Ctrl+K shortcut).
- 3. Paste the custom URI: In the 'Link to' address bar, paste your extracted 'onenote:' URI and click OK to finalize the connection.
Frequently Asked Questions
Why does my OneNote link open in the browser instead of the desktop app?
By default, OneNote places both a web-based (HTTPS) link and a desktop app (onenote:) link on your clipboard. Most applications, including Excel, will prioritize the HTTPS link when pasting directly, forcing the note to open in your default web browser.
Can I link to a specific paragraph using OneNote for the web?
No, OneNote for the web and OneNote for Windows 10 do not support paragraph-level deep links. You must use a full desktop version, such as OneNote 2016 or OneNote for Microsoft 365, to generate and follow links that route to a specific paragraph.
Is there a way to get just the desktop link without using Notepad?
Currently, OneNote bundles both links as a single clipboard item. Using an intermediary text editor like Notepad is the most reliable workaround to separate them and ensure you only copy the local 'onenote:' URI into your spreadsheet.
