#1   Report Post  
Monique
 
Posts: n/a
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Non-sequential VLOOKUP function -OR- sequential sort of web query Eric S Excel Worksheet Functions 1 February 28th 05 08:50 PM
sequential numbering of pages in a cell John Excel Worksheet Functions 0 February 10th 05 08:01 AM
automatic sequential numbering in excel or word greg2 Excel Discussion (Misc queries) 1 January 15th 05 06:35 PM
How do I set up sequential numbering on labels inventorybrokers Excel Worksheet Functions 3 November 19th 04 05:46 PM
Sequential names on Sequential pages Salt4 Excel Worksheet Functions 2 November 12th 04 05:24 PM


All times are GMT +1. The time now is 07:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"