10. Incrementing row numbers
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.
Note: If the value of cell A2 is changed, the values in all other cells change too.
Watch the Video Tutorial - https://www.youtube.com/watch?v=soSshr22eDM
Hope You Like This Tutorial - Give Comments
No comments:
Post a Comment