LessonsLearned
asked on
How can I number rows sequentially in Excel without dragging the mouse?
Is there a quicker way to number rows sequentially without dragging the mouse?
I want number rows 1 through 2000 in column A, so that
Cell A1 = 1
Cell A2 = 2
Cell A3 = 3
Cell A2000 = 2000
I normally do this by highlighting cells A1 through A3, then dragging the mouse until I get cell A2000. This takes a long time. A quicker method would be helpful.
Thank you!
I want number rows 1 through 2000 in column A, so that
Cell A1 = 1
Cell A2 = 2
Cell A3 = 3
Cell A2000 = 2000
I normally do this by highlighting cells A1 through A3, then dragging the mouse until I get cell A2000. This takes a long time. A quicker method would be helpful.
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER