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?

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

On 8 Dec 2005 18:48:40 -0800, (E-Mail Removed) wrote:

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

Ooops!

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

Ignore other post, I presume.


Gord Dibben Excel MVP

On 8 Dec 2005 18:48:40 -0800, (E-Mail Removed) wrote:

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

I don't see the logic.

--
Regards,

Peo Sjoblom

(No private emails please)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>

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.