I am creating a guest list in Excel and would like to number it from 1-200. I know there is formula but I can't remember, please help. How do I do that again? Thank you.
I am creating a guest list in Excel and would like to number it from 1-200. I know there is formula but I can't remember, please help. How do I do that again? Thank you.
Are you saying you want a column of numbers from 1 to 200? If so, type the number 1 in cell A1, then type 2 in cell A2. Select both cells (A1 and A2), then using your mouse click the Fill Handle (lower right corner) of cell A2 and drag down to row 200.
You'll have the numbers 1 to 200 in cells A1 to A200 without having to use formulas.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks