Avatar of LessonsLearned
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?

Excel Image
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!
Microsoft Excel

Avatar of undefined
Last Comment
LessonsLearned

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Robert Schutt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
LessonsLearned

ASKER
Thank you!  It worked!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck