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)


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 |
2 | abc |
3 | abc |

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

Was this topic helpful?

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.