ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sequential numbering (https://www.excelbanter.com/excel-discussion-misc-queries/16012-re-sequential-numbering.html)

Monique

Sequential numbering
 
All I do is go to next blank cell and add:
=A1+1 and use the pull handle down the column.

"jazz" wrote:

I have a list of items, numbered, say 1 to 10. When I want to enter the
next item, is there a way that I can automatically have the next number as
11? I know I can use the fill handle to create the numbered list, but I was
hoping to avoid that, and had hoped that when I tab into the particular cell,
and then tab to the next cell, it would automatically provide the next
number. Too much to ask? I am using Excel 2000. Many thanks. Jazz.



All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com