How to Make Excel First Row No Number

Author: Zeeshan Arshad     495     07/23/2018

Estimated reading time: 0 minutes, 32 seconds

Zeeshan Arshad - Lifestyle Blog

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.

« Return to Blog