ExcelBanter - how do I autofil a column with sequential numbers?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I autofil a column with sequential numbers? (https://www.excelbanter.com/excel-discussion-misc-queries/56356-how-do-i-autofil-column-sequential-numbers.html)

how do I autofil a column with sequential numbers?

Put your starting number in a cell, then hold the CTRL key and
formula-drag the cell over the required range
(that is, highlight the cell, and click the small + in the bottom
right corner of the highlight, and drag this whilst holding the CTRL
key)

Yesrek Wrote:

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=486582