|
|
|
|
|
|
|
|
| |
 Answer |
|
| |
You do not have to highlight the cells you want to fill! Enter a 1 in the
cell where you want to start. With this cell selected, hit
<Edit>,<Fill>,<Series>, Select Column, select Linear, select step value of
1, enter stop value of 300, and click on OK
"tim m" wrote:
> Hi light the cells you want to number and 'Edit'...'fill'....'series' (step
> value is how much the numbers increase by and stop value is the highest
> number.)
>
> "Birdieguy" wrote:
>
> > Without having to type each number from 1 to, say, 300, and hit the down
> > arrow or enter in between each, isn't there a command in Excel that will
> > automatically do this for you? |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
Yep! Thanks Kassie.
"kassie" wrote:
> You do not have to highlight the cells you want to fill! Enter a 1 in the
> cell where you want to start. With this cell selected, hit
> <Edit>,<Fill>,<Series>, Select Column, select Linear, select step value of
> 1, enter stop value of 300, and click on OK
>
> "tim m" wrote:
>
> > Hi light the cells you want to number and 'Edit'...'fill'....'series' (step
> > value is how much the numbers increase by and stop value is the highest
> > number.)
> >
> > "Birdieguy" wrote:
> >
> > > Without having to type each number from 1 to, say, 300, and hit the down
> > > arrow or enter in between each, isn't there a command in Excel that will
> > > automatically do this for you? |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
True, I've just always found it easier to just hi-lite a big chunk of the
column and then you don't have to selct column, and linear at least from the
default settings. You don't have to hi-lite the exact length of the fill,
just hi-lite more cells than the numbering length.
"kassie" wrote:
> You do not have to highlight the cells you want to fill! Enter a 1 in the
> cell where you want to start. With this cell selected, hit
> <Edit>,<Fill>,<Series>, Select Column, select Linear, select step value of
> 1, enter stop value of 300, and click on OK
>
> "tim m" wrote:
>
> > Hi light the cells you want to number and 'Edit'...'fill'....'series' (step
> > value is how much the numbers increase by and stop value is the highest
> > number.)
> >
> > "Birdieguy" wrote:
> >
> > > Without having to type each number from 1 to, say, 300, and hit the down
> > > arrow or enter in between each, isn't there a command in Excel that will
> > > automatically do this for you? |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Thanks Kassie. I am just learning Excell and feel totally lost, you rock!
"kassie" wrote:
> You do not have to highlight the cells you want to fill! Enter a 1 in the
> cell where you want to start. With this cell selected, hit
> <Edit>,<Fill>,<Series>, Select Column, select Linear, select step value of
> 1, enter stop value of 300, and click on OK
>
> "tim m" wrote:
>
> > Hi light the cells you want to number and 'Edit'...'fill'....'series' (step
> > value is how much the numbers increase by and stop value is the highest
> > number.)
> >
> > "Birdieguy" wrote:
> >
> > > Without having to type each number from 1 to, say, 300, and hit the down
> > > arrow or enter in between each, isn't there a command in Excel that will
> > > automatically do this for you? |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Answer |
|
| |
hi,
if it is continuous, type 1 in a2, 2 in a3, select both cells and click on
the little blac box (right down) and drop dow.
or
=IF(B1<>"",COUNTA($B$1:B1)&".","")
This formula, which is copied down to the other cells in column A, displays
the next consecutive item number if the corresponding cell in column B is not
empty. If the cell in column B is empty, the formula displays nothing.
As items are added or deleted from column B, the numbering updates
automatically.
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Birdieguy" escreveu:
> Without having to type each number from 1 to, say, 300, and hit the down
> arrow or enter in between each, isn't there a command in Excel that will
> automatically do this for you? |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Can you explain this: "click on
the little blac box (right down) and drop dow" a little more clearly?
I tried the alternate method (the formula) and couldn't get it to work for me.
Thanks!
"Marcelo" wrote:
> hi,
>
> if it is continuous, type 1 in a2, 2 in a3, select both cells and click on
> the little blac box (right down) and drop dow.
>
> or
> =IF(B1<>"",COUNTA($B$1:B1)&".","")
>
> This formula, which is copied down to the other cells in column A, displays
> the next consecutive item number if the corresponding cell in column B is not
> empty. If the cell in column B is empty, the formula displays nothing.
>
> As items are added or deleted from column B, the numbering updates
> automatically.
> hth
> --
> regards from Brazil
> Thanks in advance for your feedback.
> Marcelo
>
>
>
> "Birdieguy" escreveu:
>
> > Without having to type each number from 1 to, say, 300, and hit the down
> > arrow or enter in between each, isn't there a command in Excel that will
> > automatically do this for you? |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
OK I figured out the first method, but would still like to get the formula to
work. I guess I need to learn more about formulas.
Thank you, Marcelo.
"Marcelo" wrote:
> hi,
>
> if it is continuous, type 1 in a2, 2 in a3, select both cells and click on
> the little blac box (right down) and drop dow.
>
> or
> =IF(B1<>"",COUNTA($B$1:B1)&".","")
>
> This formula, which is copied down to the other cells in column A, displays
> the next consecutive item number if the corresponding cell in column B is not
> empty. If the cell in column B is empty, the formula displays nothing.
>
> As items are added or deleted from column B, the numbering updates
> automatically.
> hth
> --
> regards from Brazil
> Thanks in advance for your feedback.
> Marcelo
>
>
>
> "Birdieguy" escreveu:
>
> > Without having to type each number from 1 to, say, 300, and hit the down
> > arrow or enter in between each, isn't there a command in Excel that will
> > automatically do this for you? |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
I'm looking for a formula that will number my columns 1 - ?? and if i delete
a row, it will automatically fix the numbering in column A
"Marcelo" wrote:
> hi,
>
> if it is continuous, type 1 in a2, 2 in a3, select both cells and click on
> the little blac box (right down) and drop dow.
>
> or
> =IF(B1<>"",COUNTA($B$1:B1)&".","")
>
> This formula, which is copied down to the other cells in column A, displays
> the next consecutive item number if the corresponding cell in column B is not
> empty. If the cell in column B is empty, the formula displays nothing.
>
> As items are added or deleted from column B, the numbering updates
> automatically.
> hth
> --
> regards from Brazil
> Thanks in advance for your feedback.
> Marcelo
>
>
>
> "Birdieguy" escreveu:
>
> > Without having to type each number from 1 to, say, 300, and hit the down
> > arrow or enter in between each, isn't there a command in Excel that will
> > automatically do this for you? |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
Question
Notify me of replies