How to Make Excel First Row No Number

Author: Zeeshan Arshad     132     07/23/2018

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)

Solution: 

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)

Example;

ID | Name | Email
1 | abc | xyz@test.com
2 | abc | xyz@test.com
3 | abc | xyz@test.com

That's it. It will be your own custom solution.


Was this topic helpful?

Yes
No
Subscribe YouTube Channel

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.