Some people ask tough questions...

[Vasu]

I'm not sure if all version work the same, but if they want sequential numbers tell them to try right clicking the lower right corner of a cell and drag it to the end of the column or row they want to fill - when they stop dragging a menu should pop up and they just select series. If they want the same number, just left click the first cells lower right corner and drag to the end of the column or row they want to fill - this should fill all cells with the same number.

But, like I said, I'm not sure if all versions of Excel do that. My version does, so I just left or right click based on how I want the fill.

Yeah, that's alright, but sometimes even left click-dragging fills a series, and that's what makes me wonder.

[Lady-Loki]

Yeah, that's alright, but sometimes even left click-dragging fills a series, and that's what makes me wonder.

If you have a pattern established then you can left-click & drag to get the series also. Fill the first 2 cells and then highlight both and when you left-click drag you get the series. I responded for the person who was filling the first cell and trying to run the series. If there is a way to get Excel to run the sequential series with just 1 cell populated, then I'm not sure other then the right-click drag.

[Vasu]

Try typing 1 followed by some random text, then left-click drag it. You'll see what I mean.

Eg: 1 star gets dragged down to '2 star', '3 start' etc.

[Hessah]

Try typing 1 followed by some random text, then left-click drag it. You'll see what I mean.

Eg: 1 star gets dragged down to '2 star', '3 start' etc.

Yup.

Yet if you just type 1, and drag, you get 1, 1, 1, 1....

I think it has something to do with the format of the cell. Excel recognise "1 star" to be text, and when you drag that it goes 1 star, 2 star, 3 star..

but when you just type 1, it recognise it as number (usually the number are automatically right aligned as well) and it just goes 1, 1, 1, 1....

Strange that it thinks text need sequence, but number doesn't... I couldn't figure out that logic... but that's now it seems to work..

[Lady-Loki]

Try typing 1 followed by some random text, then left-click drag it. You'll see what I mean.

Eg: 1 star gets dragged down to '2 star', '3 start' etc.

That works too. I had not tried it since right/left click worked just fine. Thanks!