PC Review


Reply
Thread Tools Rate Thread

Outline numbering in Excel?

 
 
Amanda
Guest
Posts: n/a
 
      17th Dec 2003
Is there an 'easy' way to accomplish outline numbering
similar to functionality in Word? I haven't found a built-
in tool or feature, but I'm wondering if anyone has found
or written a formula or macro which may accomplish this
functionality?

Any suggestions would be greatly appreciated.

 
Reply With Quote
 
 
 
 
Kevin Stecyk
Guest
Posts: n/a
 
      17th Dec 2003
Hi Amanda,

Are you looking for something like the following solution?

http://j-walk.com/ss/excel/usertips/tip035.htm


Hope that helps.

Regards,
Kevin


"Amanda" <(E-Mail Removed)> wrote in message
news:0b0e01c3c4ad$d599d240$(E-Mail Removed)...
> Is there an 'easy' way to accomplish outline numbering
> similar to functionality in Word? I haven't found a built-
> in tool or feature, but I'm wondering if anyone has found
> or written a formula or macro which may accomplish this
> functionality?
>
> Any suggestions would be greatly appreciated.
>



 
Reply With Quote
 
 
 
 
Amanda
Guest
Posts: n/a
 
      17th Dec 2003
Thanks Kevin,

That has certainly started the gears grinding in my head,
but I still have some problems with this formula.

I'm hoping to find a way to accomplish heirarchical
numbering based on heading level...
i.e. 1 First Level Heading
1.1 Second Level Heading
1.1.1 Third Level Heading
1.1.2 Third Level Heading
2 First Level Heading
2.1 Second Level Heading

Ideally, I'll be able to create a set of macros to
emulate these headings and keep the numbering updated
when I insert or delete heading entries at the same
heirarchical level. The numbering of each level can be in
different columns if necessary, I just haven't got my
head around the formula that will accomplish this.

Probably a tall order, but I'm hoping I'm not the first
person to need this functionality.

>-----Original Message-----
>Hi Amanda,
>
>Are you looking for something like the following

solution?
>
>http://j-walk.com/ss/excel/usertips/tip035.htm
>
>
>Hope that helps.
>
>Regards,
>Kevin
>
>
>"Amanda" <(E-Mail Removed)> wrote in

message
>news:0b0e01c3c4ad$d599d240$(E-Mail Removed)...
>> Is there an 'easy' way to accomplish outline numbering
>> similar to functionality in Word? I haven't found a

built-
>> in tool or feature, but I'm wondering if anyone has

found
>> or written a formula or macro which may accomplish this
>> functionality?
>>
>> Any suggestions would be greatly appreciated.
>>

>
>
>.
>

 
Reply With Quote
 
Kevin Stecyk
Guest
Posts: n/a
 
      18th Dec 2003
Hi Amanda,

Here's a post from Harlan Grove that might be of benefit to you.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: Harlan Grove ()
Subject: Re: Word numbered outline import into Excel

Newsgroups: microsoft.public.excel.worksheet.functions
Date: 2003-07-15 14:22:29 PST

You don't need VBA, just some monster formulas. For an outline like

OLN Lvl_1 Lvl_2 Lvl_3 Lvl_4

...... (the rest follows in Google)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

You can find Harlan's post here...

http://snipurl.com/3grm

I hope that helps you.

On a side note, you should only post your question in one section. I note
that your message in listed in Excel.Misc as well. Most people here scan
all sections, so you don't really achieve much, if anything, by posting in
several sections. I mention this in passing so for your future reference.

Regards,
Kevin


"Amanda" <(E-Mail Removed)> wrote in message
news:02b601c3c4e8$f2c8f9a0$(E-Mail Removed)...
> Thanks Kevin,
>
> That has certainly started the gears grinding in my head,
> but I still have some problems with this formula.
>
> I'm hoping to find a way to accomplish heirarchical
> numbering based on heading level...
> i.e. 1 First Level Heading
> 1.1 Second Level Heading
> 1.1.1 Third Level Heading
> 1.1.2 Third Level Heading
> 2 First Level Heading
> 2.1 Second Level Heading
>
> Ideally, I'll be able to create a set of macros to
> emulate these headings and keep the numbering updated
> when I insert or delete heading entries at the same
> heirarchical level. The numbering of each level can be in
> different columns if necessary, I just haven't got my
> head around the formula that will accomplish this.
>
> Probably a tall order, but I'm hoping I'm not the first
> person to need this functionality.
>
> >-----Original Message-----
> >Hi Amanda,
> >
> >Are you looking for something like the following

> solution?
> >
> >http://j-walk.com/ss/excel/usertips/tip035.htm
> >
> >
> >Hope that helps.
> >
> >Regards,
> >Kevin
> >
> >
> >"Amanda" <(E-Mail Removed)> wrote in

> message
> >news:0b0e01c3c4ad$d599d240$(E-Mail Removed)...
> >> Is there an 'easy' way to accomplish outline numbering
> >> similar to functionality in Word? I haven't found a

> built-
> >> in tool or feature, but I'm wondering if anyone has

> found
> >> or written a formula or macro which may accomplish this
> >> functionality?
> >>
> >> Any suggestions would be greatly appreciated.
> >>

> >
> >
> >.
> >



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Manual numbering to auto (outline) numbering =?Utf-8?B?RHVrZSBDYXJleQ==?= Microsoft Word Document Management 1 4th May 2006 10:27 AM
Changing numbering in std outline screws up existing numbering? =?Utf-8?B?QnJhZCBNaWxsc3BhdWdo?= Microsoft Word Document Management 2 21st Mar 2006 10:40 AM
How do I get proper numbering level in outline numbering =?Utf-8?B?ZGFyYmVh?= Microsoft Word Document Management 1 10th May 2005 05:50 PM
Re: (Bullets and Numbering) Outline Numbering Suzanne S. Barnhill Microsoft Word Document Management 0 9th Sep 2004 06:44 PM
list numbering withing outline numbering =?Utf-8?B?TWFyeSBDPg==?= Microsoft Word Document Management 5 17th May 2004 01:44 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:56 AM.