Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How can I number rows sequentially in Excel without dragging the mouse?

Posted on 2012-12-27
2
Medium Priority
?
281 Views
Last Modified: 2012-12-27
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!
0
Comment
Question by:LessonsLearned
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Robert Schutt earned 2000 total points
ID: 38725364
I'm on an old Excel version but it may still help you: in menu Edit there is a submenu Fill, option Series...

If there is a 1 in A1 then you choose:
capture
0
 

Author Closing Comment

by:LessonsLearned
ID: 38725441
Thank you!  It worked!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question