« Return to Blog

How to Make Excel First Row No Number

Author: Zeeshan Arshad     406     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)


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 | xyz@test.com
2 | abc | xyz@test.com
3 | abc | xyz@test.com

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