Hi Cj,
You can type the number 1 into A1, then 2 into A2. Hover your mouse over the lower right corner of A2 until it becomes a + sign. Click and hold that spot, then drag your mouse downward until you get to row 200. Let go of the mouse button and you'll have automatically filled in a series from 1 to 200. You could also type 1 into A1, then click Fill > Series on the Home tab. (Series in: Columns, Type: Linear, Step Value: 1, Stop Value: 200)
Bookmarks