次の方法で共有

A tip to get a column of data from a OneNote table

  • [アーティクル]

Here's a neat trick I found to quickly use the mouse to get a column of data out of a OneNote table.

First, start with a table:

image

 

Then, move the mouse to the top of the column you want to extract:

clip_image001

Then click. The selected column will now be highlighted in blue:

clip_image002

Here's the key: grab an item you want to extract (like capybaras) and drag/drop to outside the table (and I really need to find out how to upload videos to this blog, by the way. It would make explaining this be so much easier):

clip_image003

(Notice the typo from where I mixed and matched screenshots…)

When you drop, you get this:

clip_image004

Pretty slick! This all came about because one of the testers here wanted to use a column from a table to make a simple bulleted list in another area of a notebook. This is now how he does it!

Questions, comments, concerns and criticisms always welcome,

John

Comments

  • Anonymous
    June 29, 2012
    Thanks so much for this! I have been trying for a while to move data out of tables that I've copied in from websites, I wasn't sure it could be done since the Macro recorder is not enabled for OneNote.  This is exactly the info I needed. Another of those little quirks in OneNote that I am still finding out about.

  • Anonymous
    June 29, 2012
    Glad to help!