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?

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?

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?

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?

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?

Put 1 in first cell , hold CTRL and drag down.

"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?

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?

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?

....from the bottom right corner, yes. Thank you!

"Toppers" wrote:

Put 1 in first cell , hold CTRL and drag down.

"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?

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?

If the cells to the right of the column you want to place values is not
empty, you can place a 1 in the first cell, hold ctrl+double click, and wala,
the values fill in until the right cell is empty or a cell in the column is
not blank.

"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?

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?

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?

Melissa, you said: "-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-"

Deleting a row does not affect column numbers/headers, can you explain
yourself a little better please?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35003

OK...Hard to explain.

Column A. I want to number 1- 400 lets say. Then when i have an employee
delete a row because they are removing an item, i want column A to fix it's
numbering.

Example for Column A
1
2
3
4
5
Row 3 gets deleted, it then looks like below
1
2
4
5

can the column automatically fix itself or can the grey column with the
numbers be displayed. This one is hard for me to figure out.

"Simon Lloyd" wrote:


Melissa, you said: "-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-"

Deleting a row does not affect column numbers/headers, can you explain
yourself a little better please?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35003

Melissa, join our forums and then go to this thread
http://tinyurl.com/5qa83j and post a reply but before submitting scroll
down a little further you will see a "Manage Attachments" button click
this and upload a workbook where i can help you further.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35003

I'm looking for help on autmatic numbering, and if a row is deleted the
column renumbers.

As you can see in my attachment. If one of my mechanics deleted line
13 lets say, i then need to know how many machines are available and the
bottome number would be off. When you delete a row can the number
renumber accordingly. Am I saying this right?

melissa


+-------------------------------------------------------------------+
|Filename: Copy of 12-1-08.xls |
|Download: http://www.thecodecage.com/attachment.php?attachmentid=23|
+-------------------------------------------------------------------+

--
MGAUDIO
------------------------------------------------------------------------
MGAUDIO's Profile: http://www.thecodecage.com/forumz/member.php?userid=43
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35003

Welcome to The Code CageFirstly why the gap
in the blocks of time?, secondly will there always be 14 in each time
slot? and more specificly why number them atall in that way?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35003

im using this new version of Excel which has no 'edit'. it looks like this:



"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?

i have no "edit" mine looks like



"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?

Sarah

On Home tab go to far right to "Editing" section.

Click on the downarrow icon to see a list of fill options.


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 09:54:01 -0700, sarah
wrote:

im using this new version of Excel which has no 'edit'. it looks like this:



"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?

"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?

As you have not detailed your question, I would suggest entering =row()
in A1and pull down as needed


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94158

"sarah" wrote:

im using this new version of Excel which has no 'edit'. it looks like this:



"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?