excel question

N

nomak

Limp Gawd
Joined
Oct 20, 2004
Messages
419
I have a spread sheet that has the number 1 thru 100 using as labels. I want to change the 1 to 101 and the rest of the labels to adjust accordingly as well... example...

101,102,103,104,105... thru 200....etc etc,....


How do I achieve this without changing each number manually ? thanks,.
 
Enter the number 101 in the first cell and select that cell.

Edit -> Fill -> Series

Columns, linear, step value 1, stop value 200.
 
Or just change the first cell to 101 and then, using the mouse, select the cell at the bottom right corner (when the cursor changes to the crosshair) and drag it down the fields
 
thanks for the help it worked bollweevil..


Thedot I tried your method but with no luck. I will keep trying though. thanks..
 
another question.. lets say I have some letters in front of the number like NM100 and want to continue a series incrementally increasing by one how do I do that...thanks....
 
TheDot's method will work with letters in front of the numbers.

It will also work with just numbers - after you drag down the series there should be an auto-fill box at the bottom-right of the last cell. Click the drop-down and choose 'fill series.'
 
Im using version 2002 by the way and am having no success with the dots method...thanks
 
Use more than one cell to start your fill.

Type the first 2 or 3 cells:

NM100
NM101
NM102

Then select all three cells and then fill using the crosshairs at the bottom right corner. Drag down (or over) as far as you need to go and that's it.

This also works with formulas, and Excel is "smart" enough to change the forumla for the corresponding row/column. It also works with dates, times and series IE NM100, NM110, NM120 it would know to do NM130 next and so on.
 
Thats what I ended up doing. the cells were previously filled with data already so I erased it all and started from scratch and it worked.. thanks everyone..
 
the smart feature is prolly one of the best kept secrets - when i learned how to do it i was amazed at how awesome it was!
 
He's talking about what I said here
nomar said:
This also works with formulas, and Excel is "smart" enough to change the forumla for the corresponding row/column. It also works with dates, times and series IE NM100, NM110, NM120 it would know to do NM130 next and so on.
Click to expand...
 
You must log in or register to reply here.
Back
Top