![Names Names](https://exceljet.net/sites/default/files/styles/function_screen/public/images/formulas/create%20email%20address%20from%20name.png?itok=gutu-WZ9)
When you open Excel, a blank workbook is automatically opened. To change the name, double-click on the sheet's tab and then type the new name. What heading, you can make the top rows and leftmost columns into headers. To use AutoFill with formulas, insert the formula and make sure it works (more about. Tip: Instead of manually entering defined names in formulas, you can have Excel do it automatically for you. To do that, go to the Formulas tab, in Defined Names group, click Use in Formula, and then select the defined name you want to add. Excel will add the name to the formula.
Now let’s say you want to automatically number rows up to 10000 or 100000 and you want to do this in a one go. Maybe it’s a pain with fill handle but, you can use fill series to generate a column with serial numbers in a one go. Here are the steps. Select the cell from where you want to start your serial numbers and insert “1” in it.
Now, go to home tab ➜ editing ➜ fill ➜ series. In the series window, do the following. Series In = Column.
Step Value = 1. Stop Value = 10000 or whatever you want up to.
If you have data whether small or large it is must to add serial numbers to it. The one thing which you really need to understand that a serial number give a unique identity to each entry. And, with all the methods you have learned above it’s no big deal to create a serial number column in the data, no matter which situation you are in. I hope you found this useful, but now, tell me one thing.
![Get Get](/uploads/1/2/5/5/125512481/357001104.png)
Which method you prefer to insert serial numbers? Please share your views with me in the comment section. I'd love to hear from you and please don’t forget to share it with your friends, I am sure they will appreciate it. You must Read these Next.: Unlike Word, in Excel, there is no default option to insert bullet points.