Question: how to make 1 to 100 in excel?
Answer: Enter a 1 in row 1. Right-click on bottom right corner of cell and drag. down to row 100. ... 
Enter a 1 in row 1. Edit>Fill>Series>Linear>Step=1 Stop=100.
Enter a 1 in row 1 cell, a 2 in next cell down. Left-click and drag down. to row 100.
In row 1 enter =Row(). Drag>copy down to row 100.