Autofill + Hard return

M

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?
 
G

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
 
G

Gord Dibben

Ooops!

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

Ignore other post, I presume.


Gord Dibben Excel MVP
 
M

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.
 
Top