Estimated reading time: 0 minutes, 32 seconds
Problem: I wanted to make first row header so that my data #1 should start from second row, instead of first row (that is header row)
1- Add a Column ID (as first column, in first row)
2- Enter 1, and 2 (in two rows of ID column)
3- Select both rows of ID column
4- Drag them down to as long as you want your auto-number to grow (so the 2nd row will start from #1 up to #100 or more up to you)
ID | Name | Email
1 | abc | email@example.com
2 | abc | firstname.lastname@example.org
3 | abc | email@example.com
That's it. It will be your own custom solution.
Zeeshan Arshad is a self-taught and multi-dimensional person with extraordinary track record of success with international clients and students.
Feel free to contact him for your project, training purpose or guidance.