XLNotes EXCEL Add-in

< Next Topic | Back to topic list | Previous Topic >

Pages: < 1 2 3 4 >

Posted by Alexander Deliyannis
Apr 14, 2012 at 06:02 PM

Here’s a simple example in Excel 2007/10:

- Select rows 2 to 4
- On the ribbon, click Data / Group / Group: this should create a first collapsible level
- Select rows 1 to 5
- Again, click Data / Group / Group: you should now have an additional, outer level

That’s the logic; always remember that the limits of higher levels should be outside those of lower ones, e.g. you can’t create the second level for rows 1 to 4.

It also works with columns in the same way. You can have both at the same time, i.e. a 2-dimensional collapsible outline.

Mitchell Kastner wrote:
>I cannot figure out how to create a hierarchical structure in Excel. Something to do
>with the grouping function. Is there a straightfoward explanation on how to create a
>tree?
> >Cheers

Posted by Alexander Deliyannis
Apr 14, 2012 at 06:05 PM

XLnotes, I for one appreciate your reaching out to the forum with more info. The product has been briefly mentioned here in the past, and I remember that I had once tried to trial it and it was not available, with an announcement that it was being further developed I think.

I think that it provides an interesting solution for people with a lot of freeform data who do not think in outlines.

Posted by Jack Crawford
Apr 15, 2012 at 01:45 AM

@XLNotes

Thanks for the personal response.

I’ll take a peek at the new version. No promises though ...

;-)

Posted by Jack Crawford
Apr 16, 2012 at 01:47 AM

TonyJ wrote:

>Perhaps technical issues prevent it, but I think an Excel and
>OneNote combination would be more appealing to the market. It would certainly get my
>attention.

You probably already know this, but you can manually create links between Excel and OneNote by placing OneNote hyperlinks in Excel cells. Just right-click on a ON tab and ‘Copy hyperlink to this page’. Paste the link into Excel. Clunky but it seems to work.

Posted by Gnomexor
Nov 5, 2013 at 08:02 PM

Any word on whether XL Notes 8.0 is still available? The website xlnotes.com is no longer active. I would really like to use the full version because I have already hit my 15 comment limit on the free version.
If they are out of business is there a way to get a license key to unlock the full version?

Pages: < 1 2 3 4 >

Back to topic list