capture.png

<div>
Thank you! &nbsp;It worked!
</div>


<div>
<div class="content wysiwyg-content">
Is there a quicker way to number rows sequentially without dragging the mouse?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/12_w52/624239/excel2.jpg" target="_blank" title="Excel Image (41 KB)"><img alt="Excel Image" class="file-block lazyload" style="max-width: 158px;" data-src="https://filedb.experts-exchange.com/incoming/2012/12_w52/624239/excel2.jpg" /></a><br />
I want number rows 1 through 2000 in column A, so that<br />
<br />
Cell A1 = 1<br />
Cell A2 = 2<br />
Cell A3 = 3<br />
Cell A2000 = 2000<br />
<br />
I normally do this by highlighting cells A1 through A3, then dragging the mouse until I get cell A2000. &nbsp;This takes a long time. &nbsp;A quicker method would be helpful.<br />
<br />
Thank you!
</div>
</div>


excel2.jpg

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!

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.