Autofill + Hard return

[menlo11]

The cell I want to fill from looks like this:
3
3

When I fill, I want the cells to look like this:
3 | 4 | 5
3 | 4 | 5

Instead, the cells look like this:

3 | 3 | 3
3 | 4 | 5

Is there any way to fix this?

 

[Gord Dibben]

Select the two cells then right-click on the fill handle and drag across as
far as you wish.

Release the button and select "Fill Series".


Gord Dibben Excel MVP

 

[Gord Dibben]

Ooops!

Don't know what you mean by " + hard return"

Ignore other post, I presume.


Gord Dibben Excel MVP

 

[Peo Sjoblom]

I don't see the logic.

--
Regards,

Peo Sjoblom

(No private emails please)

 

[menlo11]

I'm making labels and the person requesting the labels wants two labels
on the same label. So that is why I need to put the same number twice
in the same cell.