Dragging Cells to Create Ascending Numerical List

[J. Danniel]

Hello everyone.
I'm using Excel 2000.

I created a column, and in the first cell, I typed the number 1. I then
tried to drag down so each subsequent cell has the next number in sequence,
but all the cells contained the number 1.

In other words, I want the cells to appear as follows:
1
2
3
4
5
6
etc.

But they're all
1
1
1

What should I do to get an ascending numerical list in this column?
(It's probably so simple, I'm overlooking it.)

Thank you!
J. Danniel

--
To reply via e-mail, please
remove the letter Z from the e-mail address.
Thank you very much!
Jack D.

[Tom Ogilvy]

Method 1:
Put a 1 in the first cell, a 2 in the second, then select both and drag.

Method 2
Put a 1 in the first cell. Hold down the control key while you drag.

Regards,
Tom Ogilvy
MVP Excel

J. Danniel <zj...@prodigy.net> wrote in message
news:#ALBOde3$GA....@cppssbbsa02.microsoft.com...

[Gord Dibben]

Enter 1 in row 1 and 2 in row 2 then do your drag down. Excel needs
to know that you want a sequential fill.

Or enter 1 in row 1 then highlight the range you want to fill then
Edit>Fill>Trend.

HTH Gord

On Sat, 24 Jun 2000 10:20:12 -0400, "J. Danniel" <zj...@prodigy.net>
wrote:

[David McRitchie]

To cover the use of the Ctrl key a bit more thoroughly when
using the fill handle to replicate cells..

Some things to note when you want to increment constants
The use of the control key will cause a different result.

1) dragging the fill handle of a single cell with a number
will replicate down without incrementation.
2) Ctrl + drag will increment a single cell selection with
a numeric constant. It will not increment constants in
multiple cell selections if there is no increment.
i.e. A1:B1 with constants will not increment downward.
3) Letters are the opposite. A single cell letter constant
will increment through the alphabet with the fill handle.
4) Ctrl + drag fill handle will not increment a single cell
letter constant as it is replicated down.

with multiple cell selections:
5) you must include an increment cell in the direction
you fill to get incrementation (both numbers and single letters)
6) Hold the Control key down will only fill down repeating
groups of cells.

You can make your own custom lists
Tools, Options, Custom Lists
Sun,Mon,Tue,Wed,Thu,Fri,Sat

The above has not been placed onto my fillhand.htm page yet.

HTH,
David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm

[Dave Peterson]

Another option is to rightclick (and hold) the autofill button and drag down.

Excel will prompt you for what you want to do.

copy or fill series and a bunch of other stuff.

"J. Danniel" wrote:
>
> Hello everyone.
> I'm using Excel 2000.
>
> I created a column, and in the first cell, I typed the number 1. I then
> tried to drag down so each subsequent cell has the next number in sequence,
> but all the cells contained the number 1.
>
> In other words, I want the cells to appear as follows:
> 1
> 2
> 3
> 4
> 5
> 6
> etc.
>
> But they're all
> 1
> 1
> 1
>
> What should I do to get an ascending numerical list in this column?
> (It's probably so simple, I'm overlooking it.)
>
> Thank you!
> J. Danniel
>

> --
> To reply via e-mail, please
> remove the letter Z from the e-mail address.
> Thank you very much!
> Jack D.

--

Dave Peterson
pete...@freewwweb.com

[David McRitchie]

Hi Dave,
Thanks for quick note on RtMouse operation of the fill handle,
I've added that to my page will be in effect next update.
http://www.geocities.com/davemcritchie/excel/fillhand.htm

David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm

Dave Peterson <pete...@freewwweb.com> wrote ...

[lbr]

Hold down the Ctrl key before you start dragging.

Regards

LBR

J. Danniel <zj...@prodigy.net> wrote in message
news:#ALBOde3$GA....@cppssbbsa02.microsoft.com...

[Peltier]

Everyone always asks me how I learned so much (which admittedly is much
less than some of you experts know). I tell them they have to click
with the right button from time to time, and see what Excel (Word,
PowerPoint, etc.) suggest they do.

- Jon

[Marguerite Lombard]

If you have in the first cell a 1 and the second a 2, highlight both and
then drag the copy sign (the plus sign in the corner) the rest of the
numbers will increase. Excel needs a pattern to suggest the trend - if you
highlight one cell only, it could assume you want it to expand with that
cell's value only, if you highlight more than one cell, the trend for the
expansion is suggested. This sounds long-winded - email me if you don't
follow.

Laurence

[veronique...@gmail.com]

Brilliant! Thanks!

[ggra...@gmail.com]

Works Great! Thanks

[zahid....@gmail.com]

This is the great option

"Another option is to rightclick (and hold) the autofill button and drag down.
Excel will prompt you for what you want to do.

copy or fill series and a bunch of other stuff." But in my excel worksheet only i am able to choose copy cell option, the other options are dim / not able to select. Can you suggest the solution?

[sharee.c...@romaclumber.com]

On Saturday, June 24, 2000 at 3:00:00 AM UTC-4, Tom Ogilvy wrote:
> Method 1:
> Put a 1 in the first cell, a 2 in the second, then select both and drag.
>
> Method 2
> Put a 1 in the first cell. Hold down the control key while you drag.
>
> Regards,
> Tom Ogilvy
> MVP Excel
>
>
>

> J. Danniel <zj...@prodigy.net> wrote in message
> news:#ALBOde3$GA....@cppssbbsa02.microsoft.com...

This was super easy and worked PERFECTLY! Thank you!! Tom Oqilvy!

--

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender. Please
note that any views or opinions presented in this email are solely those of
the author and do not necessarily represent those of Ro-Mac Lumber &
Supply, Inc. Finally, the recipient should check this email and any
attachments for the presence of viruses. Ro-Mac Lumber & Supply, Inc
accepts no liability for any damage caused by any virus transmitted by this
email.