How do do auto Heading Numbers like in Word?

R

rajeshk4u

In Word you can have Chapter Numbers, Heading Numbers.....where the
number can auto-increment (or decrement). I am looking for a similar
feature in Excel.


Basically I have an Excel spreadsheets like this:
=========================================
Scenario #1---->

: (calculations)
..
------------------------------
Scenario #2--------->

: (calculations)
..
-----------------------------
Scenario #3

: (calculations)
..

=========================================

So I want the "Scenario #1" to be an auto-number, like heading numbers
in Word. So if I delete or insert a "Scenario" the numbers should
change accordingly. But I can't find anything in Excel that behaves in
this way.

I am using an old version of Excel....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top