INCREMENTING ROW NUMBERS USING MICROSOFT EXCEL

Standard row numbering in Excel is often used, but you can also create your own numbering system in a table, such as incrementing by 10 as described below.

To increment row numbers by 10:

1. Select cell A2 and type 0.
2. Select cell A3 and type the following formula: =A2+10.
3. Select cells A3:A12.
4. From the Edit menu, select Fill and Down.

INCREMENTING ROW NUMBERS USING EXCEL

Note: If the value of cell A2 is changed, the values in all other cells change too.


Watch the Video Tutorial


Incrementing Row Numbers Using Excel, Microsoft Excel Tutorials, Microsoft Excel Video Tutorials, Pivot Table Usage In Microsoft Excel