OneNote PowerToys

A Collection of PowerToys for OneNote

Send to Excel?

January28

James used the contact form to ask about Excel and OneNote:

Pull in a Excel shreadsheet into OneNote and retain the cell formating?

It would be great if it could also mantain the formulas, but thats a plus only.

According to a comment on Brad Covelle’s Blog (link broken, details in previous post here) there was a similar powertoy that was a Contest Winner, but I can’t find it on the public internet…

Send to OneNote by Piyush Shah

  • This Powertoy adds a Send to OneNote into the right-click Send To menu in Windows Explorer.
  • Put a button in Excel and PowerPoint to send the selection / entire document to OneNote.

OneNote 2007 has a basic table layout, so a simple Copy/Paste will produce a table with most of the basic formatting. The row/column width data is lost and ON2007 doesn’t support Borders, so it won’t look quite the same.

OneNote 2007 does have Insert Files as Printout which produces a searchable image and looks much better, but the data can’t be modified.

OneNote 2007 also allows Hyperlinks to files, so that would be my suggested route.

Anyone have a better suggestion? Preferably something that works in 2003 as well (such as how to get Piyush’s PowerToy and what it’s out output looks like.)

Share and Enjoy:
  • Digg
  • del.icio.us
  • Facebook
  • Google
  • Ma.gnolia
  • StumbleUpon
  • Technorati
posted under Trying to Find!

Viewing 1 Comment

    • ^
    • v
    Off the topic a bit, but this type of functionality is support by MindJet's MindManager product (www.mindjet.com).

    You can select a range of cells from an Excel spreadsheet, push it to MindManager, which displays the cells in the range and retains a link back to your original spreadsheet file. You can even edit the cells from w/in MindManager and it will update your spreadsheet. MM6 also supports creating a mini-spreadsheet right within a mindmap, without using Excel at all.

    p.s. I'm NOT related to the company, its subsidiaries, owner, employees, etc. in any way. Just a happy customer who also likes OneNote.
close Reblog this comment
blog comments powered by Disqus