![]() |
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