Video tutorial on how to type numbers automatically in Excel features
The Office suite has various features and menus. One of these features is Excel, which has many applications in the field of engineering, administrative, financial and accounting.
features , One of the applications of Excel program for drawing tables, drawing diagrams, writing formulas, preparing databases, dashboards and column numbering is for quick and easy calculations and.. Excel program has the ability to perform these calculations accurately and away from errors and mistakes, and few people have not used Excel to store and analyze accounting or mathematical information.
How to type numbers automatically in Excel:
What we deal with a lot in Excel is entering numbers in columns. But doing this manually is time consuming. So you have to find an automatic way to do this. For this purpose, we first load a table like the following table. Our intention is to enter the row number and register the national code in front of it.
The best and fastest way to enter row numbers automatically is to first write the number 1 in column A2 and then click on the cursor and drag this number as far as you like, as shown below.
Now click on the menu that has been created (Auto Fill Aptions) and select the Fill Series option from the menu that opens to change the selected numbers as shown in the image below.
But if you want to do this using a function, the easiest way is to use the ROW function . That is, in cell A2, type the following formula and then drag it: 1 – () ROW =
Another function through which you can do the same is the OFFSET function . When using this function, the cell above cell A2 must be empty or zero. So you have to type the following formula in the same cell A2: +1 (OFFSET (A2, -1,0 =
After clearing the row title, press the Enter key and drag the resulting answer in cell A2 as much as you need.
If you want, enter the personal national code in the second column so that the number counter is in the number column. In other words, you want to do something. Whenever you write something in column B, then the counter is automatically placed in column A. To do this, just enter the following formula in cell A2: IF (B2 <> ””, ROW () – 1, ””) K =
Copy this formula in each cell of the first column. From now on, you can register any code in the second column and see the counter in the first column, which is registered automatically. Like the image below:
It should be noted that in the articles published on the quick and easy site, an attempt has been made to present the content in a new way and in the most concise and complete form possible, but if you have any questions about this part of Excel training, please let us know in the comments section. features