Ask Experts Questions for FREE Help !
Ask
    alcon0300's Avatar
    alcon0300 Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Sep 16, 2008, 09:41 AM
    Microsoft Excel Automatic Numbering
    I have an existing excel spreadsheet, & I want to go back in, create another column, & automatically number it, starting at 1 & going on sequentially. According to the help, I started the numbering, 1,2,3 & used the FILL command (down). It then changes all the highlighted cells to 1!! I can number all the cells manually, but then I won't be able to go back in & insert any rows without messing up the numbers.
    Help!
    ebaines's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
    		  
    #2

    Sep 16, 2008, 10:26 AM
    Try this - put a 1 in the first cell, and a 2 in the second, then highlight the complete range of cells (including the 1 and 2), and go to Edit.. Fill.. Series. It should default to a step value of 1 and type "linear." See if this works.
    Depressed in MO's Avatar
    Depressed in MO Posts: 571, Reputation: 94
    Senior Member
    		  
    #3

    Sep 16, 2008, 10:33 AM
    Another quick and easy solution to do this is within your first cell, type in the number 1. Underneath that, type in the number 2. Underneath that, type in the number three. Highlight cells 1, 2, and three. While these cells are highlighted, take your curser on the corner of cell number 3 and drag it down as far as you need it to go. This should number it in sequence as you are trying to do (ex. 1, 2, 3, 4, 5, etc... )
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Sep 16, 2008, 11:00 AM
    I can number all the cells manually, but then I won't be able to go back in & insert any rows without messing up the numbers.
    Um, putting numbers in a cell either manually or by the fill tools will STILL result in the problem you're describing. The numbers will be static. If you later go back and insert a row between 5 and 6, the 6 WILL move down. So, I think you have the wrong solution.

    Why are you wanting to number them? So they will print? I know your way is cleaner, but you will always have to manually repair them if you insert... so...

    I'd suggest you just got into FILE > PAGE SETUP > SHEET and check the Row and column headings box. Now the sheet will print with the numbers and you don't have to manually insert/update them.

    Your choice.
Not your question? Ask your question View similar questions
 

Add your answer here.


Check out some similar questions!

Sequential numbering in Excel [ 3 Answers ]

Hi, I'm trying to number a column in sequential order by counting the number of times a certain word is typed in another range. For example: AAA 1 BBB 1 AAA 2 AAA 3 CCC 1 I need the numbers to be in sequence in column B:B every time a word is typed multiple times in column A:A.

Microsoft Excel running VERY slowly [ 2 Answers ]

I have recently upgraded two computers at work one runs as a server for 5 others. The one machine was running exceptionally slowly especially opening Excel files. I upgraded both machines with 1GB of ram thinking this would make them really fly ( they were 256meg previously) but no - the machine...

Automatic adition in Excel [ 7 Answers ]

Hey, Is anyone good in Excel? I have a spreadsheet I have to make for every file at work and I need it to add costs automatically. Basically in a file I will have 30-40 items and each item has a cost, I have to add a certain markup (its not a percentage, just a flat fee that is the same for all...

Microsoft Excel 2003 takes more mem usage [ 3 Answers ]

Is there any way to reduce excel 2003 mem usage to be reduced? One of my applications runs fine on Excel 2000 and fails in Excel 2003 with low virtual memory capacity error. Under task manager on looking into the "mem usage" for Excel 2000 its around 30MB and in Excel 2003 its DOUBLE!! Any...

View more questions Search