Monthly Archives: April 2015

Outline (or WBS) Numbering in Excel without Macros

Problem:  In an Excel spreadsheet, I want to do outline-numbering, sometimes called “work-breakdown structure” (WBS) numbering, without resorting to macros.  I would like to automatically form this type of numbering:



If you want to solve this problem and you don’t want to use macros, then you will need to devote a bit of spreadsheet real estate (extra columns) and use some fairly tedious-looking (but simple) formulas.

Continue reading