Adding numbers to a column

Posted: 11-19-2006, 01:54 AM
I'm sure this is an easy task, but can't fugure out how to do it.

I have a column and wish to place number "1" in the top cell and then
to to count each cell in that column automatically (e.g. the top cell
is "1" followed by "2", then "3" etc).

Thanks in advance,

Danny

Reply With Quote

Responses to "Adding numbers to a column"

JE McGimpsey
Guest
Posts: n/a
 
Re: Adding numbers to a column
Posted: 11-19-2006, 03:01 AM
In article <1163901243.738797.48310@h48g2000cwc.googlegroups. com>,
"ausdan" <ausdan@gmail.com> wrote:
> I'm sure this is an easy task, but can't fugure out how to do it.
>
> I have a column and wish to place number "1" in the top cell and then
> to to count each cell in that column automatically (e.g. the top cell
> is "1" followed by "2", then "3" etc).
One way:

Enter 1 in the top cell. While holding the CTRL-key, click and hold the
"fill handle" (lower right corner of the cell) and drag down. Choose
Fill Series from the pop-up menu.

another:

Enter 1 in the top cell and 2 below it. Select the two cells. Click and
hold the fill handle of the bottom cell and drag down.

and another:

Enter 1 in the top cell (say, cell A1). In the cell below it, enter

=A1 + 1

Select the second cell, copy down as far as desired.

yet another:

Enter 1 in the top cell. Select the range you want to fill. Choose
Edit/Fill/Series..., click OK.
Reply With Quote
CyberTaz
Guest
Posts: n/a
 
Re: Adding numbers to a column
Posted: 11-19-2006, 03:56 AM

On 11/18/06 10:01 PM, in article
jemcgimpsey-173249.20013718112006@msnews.microsoft.com, "JE McGimpsey"
<jemcgimpsey@mvps.org> wrote:
> In article <1163901243.738797.48310@h48g2000cwc.googlegroups. com>,
> "ausdan" <ausdan@gmail.com> wrote:
>
>> I'm sure this is an easy task, but can't fugure out how to do it.
>>
>> I have a column and wish to place number "1" in the top cell and then
>> to to count each cell in that column automatically (e.g. the top cell
>> is "1" followed by "2", then "3" etc).
>
> One way:
>
> Enter 1 in the top cell. While holding the CTRL-key, click and hold the
> "fill handle" (lower right corner of the cell) and drag down. Choose
> Fill Series from the pop-up menu.
>
> another:
>
> Enter 1 in the top cell and 2 below it. Select the two cells. Click and
> hold the fill handle of the bottom cell and drag down.
>
> and another:
>
> Enter 1 in the top cell (say, cell A1). In the cell below it, enter
>
> =A1 + 1
>
> Select the second cell, copy down as far as desired.
>
> yet another:
>
> Enter 1 in the top cell. Select the range you want to fill. Choose
> Edit/Fill/Series..., click OK.
And here is a 5th - Type 1 into the first cell then hold Option while
dragging the Fill Handle... Just like JE's first choice, but bypasses the
shortcut menu/Fill series step :)

Regards |:>)
Bob Jones
[MVP] Office:Mac

Reply With Quote
shunulu@gmail.com
Guest
Posts: n/a
 
Re: Adding numbers to a column
Posted: 11-20-2006, 01:17 PM
And here is 6th.; write "1" hit enter, write "2" hit enter, write "3"
hit enter... etc. :P

Reply With Quote
 
LinkBack Thread Tools Display Modes
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find the last entry in a column of numbers John Mac Office Excel 2 10-11-2006 12:11 PM
adding on a column... nobuko_nagaoka@adobeforums.com Mac Indesign 4 08-21-2006 10:26 PM
Adding numbers in a column- Excel 98 Charlie Mac Office Excel 2 03-24-2006 06:52 AM
Missing row numbers and column letters nemotski@macunlimited.net Mac Office Excel 4 12-10-2004 09:33 AM
Numbers not adding up Big Jilm Mac Office Excel 1 03-04-2004 09:58 AM


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90