Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gimmie LotsForNothing - 19 Sep 2003 06:20 GMT

In an MS Excel spreadsheet how does one get a cell to automatically increase
a numeric data when dragged to the right.
For instance if you enter Mon in cell a1 then drag that cell 4 cells to the
right it will display Mon,Tue,Wed,Thurs,Fri.
How can you get the same effect using numbers?

Reply to this Message

Eva Shanley - 19 Sep 2003 16:30 GMT

Hold down your Ctrl key while you're dragging to increment
by 1.

>-----Original Message-----
>In an MS Excel spreadsheet how does one get a cell to automatically increase
[quoted text clipped - 4 lines]
>
>.

Reply to this Message

Dave Peterson - 20 Sep 2003 02:11 GMT

Excel needs some help to help you.

If you put 1 in the first cell and 2 in the second and then select both and
drag, you'll get the series you want.

But I like to just put the 1 in the cell and rightclick on the autofill button
and drag it. When I let go of that rightclick, excel will ask me how I want
that range filled in. (I can choose "fill series".)

> In an MS Excel spreadsheet how does one get a cell to automatically increase
> a numeric data when dragged to the right.
> For instance if you enter Mon in cell a1 then drag that cell 4 cells to the
> right it will display Mon,Tue,Wed,Thurs,Fri.
> How can you get the same effect using numbers?

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message