Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now		 3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Software > Spreadsheets   »   Auto Generating Sequential Numbers in Excel 2003

Answer this Question Ask about Spreadsheets
 
Thread Tools Display Modes
Question
 
 
#1  
Old Apr 27, 2008, 12:50 PM
AJKT
New Member
AJKT is offline 		 
Join Date: Apr 2008
Posts: 1
AJKT See this member's comment history on his/her Profile page.
Auto Generating Sequential Numbers in Excel 2003
Hello All
I would like to have sequential Auto Generated Numbers in column A of my Excel 2003 Spreadsheets e.g A1=1, A2=2, A3=3 etc. But I would like Excel to auto generate this number, rather than input?

Reply With Quote
 
     

Answers
 
 
Old Apr 27, 2008, 10:08 PM   #2  
Software Expert
JBeaucaire is online now
 
JBeaucaire's Avatar
 
Join Date: Jan 2008
Location: (Call me JB) Bakersfield, CA
Posts: 3,379
JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.JBeaucaire See this member's comment history on his/her Profile page.
Pay to call JBeaucaire for advice ($.75/min)
Call JBeaucaire via Skype™
Enter the value 1 in cell A1

enter the formula =A1+1 in cell A2

Copy cell A2 to A3:A100 and the numbers will populate.
  Reply With Quote
 
     
 
 
Old Apr 28, 2008, 03:21 PM   #3  
Junior Member
mdosh01 is offline
 
Join Date: Dec 2007
Posts: 33
mdosh01 See this member's comment history on his/her Profile page.
Alternatively, Enter the value "1" in cell A1.

Then select Edit, Fill, Series from the menu. Change "Series In" to "Columns". Enter a stop value, say "100".

Comments on this post
JBeaucaire agrees: Love it!
  Reply With Quote
 
     
Answer this Question Ask about Spreadsheets

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

 
Similar Sponsors

Similar Threads
Question Asker Forum Answers Last Post
padding numbers in excel joed123 Spreadsheets 2 Apr 10, 2008 05:43 AM
Auto-Macro in Excel Wonder84lalala Other Databases 2 Mar 8, 2008 02:17 PM
Excel: Convert numbers to date Smith21000 Spreadsheets 1 Jul 17, 2007 11:28 AM
MS Excel spreadsheet changing numbers zix Spreadsheets 1 Mar 24, 2006 05:28 AM
Sequential numbering in Excel marzocchi Spreadsheets 1 Feb 15, 2005 02:53 PM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 01:32 PM.