Numbering Range Quickly
There is an Excel file that teaches how to perform the Numbering Range Quickly operation.
Excel Dashboard for Numbering Range Quickly
This workbook demonstrates numbering range quickly using VBA macros on a 9-row data layout.
Hope it is useful.