How to copy a cell and horizontally expand the paste along header
 

Hi all,
I know how to do this action on a vertical way:
- Prerequisite: the first column is filled in on 10 rows high;
- Select the top cell of the second column;
- Double-click on the black bold cross in the lower-right of this cell.
As a result, the content (for instance, a function) of the selected cell is
pasted downward alongside the first column, until the end of it (and no
more).
Now the question: how can we perform this action on an horizontal way (first row filled in on 10 columns long and select/double-click the leftmost cell of a second row alongside the first row)?
A helpful answer would be really appreciated!! ;-)
By the way, in case you know how to perform these 2 actions without using
the mouse, I take it as well :-)
Thx in advance for any kind of help,
Bye

How to copy a cell and horizontally expand the paste along header
 

Which Ver. of Excel are you talking about. In Xl2003 we don't have such a
property.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"al7riv" wrote:

Hi all,
I know how to do this action on a vertical way:
- Prerequisite: the first column is filled in on 10 rows high;
- Select the top cell of the second column;
- Double-click on the black bold cross in the lower-right of this cell.
As a result, the content (for instance, a function) of the selected cell is
pasted downward alongside the first column, until the end of it (and no
more).
Now the question: how can we perform this action on an horizontal way (first row filled in on 10 columns long and select/double-click the leftmost cell of a second row alongside the first row)?
A helpful answer would be really appreciated!! ;-)
By the way, in case you know how to perform these 2 actions without using
the mouse, I take it as well :-)
Thx in advance for any kind of help,
Bye

How to copy a cell and horizontally expand the paste along header
 

Double-click to fill only works filling down, not across.

You have to use some other method of copying across.

I know of no way to simulate the d-click filldown using the keyboard.


Gord Dibben MS Excel MVP

On Fri, 6 Feb 2009 12:46:01 -0800, al7riv
wrote:

Hi all,
I know how to do this action on a vertical way:
- Prerequisite: the first column is filled in on 10 rows high;
- Select the top cell of the second column;
- Double-click on the black bold cross in the lower-right of this cell.
As a result, the content (for instance, a function) of the selected cell is
pasted downward alongside the first column, until the end of it (and no
more).
Now the question: how can we perform this action on an horizontal way (first row filled in on 10 columns long and select/double-click the leftmost cell of a second row alongside the first row)?
A helpful answer would be really appreciated!! ;-)
By the way, in case you know how to perform these 2 actions without using
the mouse, I take it as well :-)
Thx in advance for any kind of help,
Bye

How to copy a cell and horizontally expand the paste along header
 

Double-click on the fill handle to fill down has been a feature for many
versions of Excel, including 2003

Are you set to allow cell drag and drop?


Gord Dibben MS Excel MVP

On Fri, 6 Feb 2009 13:55:01 -0800, Khoshravan
wrote:

Which Ver. of Excel are you talking about. In Xl2003 we don't have such a
property.

How to copy a cell and horizontally expand the paste along hea
 

I am using Xl2003 but d-clicking the fill handle does not work in my XL. Does
it need to be activated some where in the XL?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Gord Dibben" wrote:

Double-click on the fill handle to fill down has been a feature for many
versions of Excel, including 2003

Are you set to allow cell drag and drop?


Gord Dibben MS Excel MVP

On Fri, 6 Feb 2009 13:55:01 -0800, Khoshravan
wrote:

Which Ver. of Excel are you talking about. In Xl2003 we don't have such a
property.

How to copy a cell and horizontally expand the paste along hea
 

Does not have to be activated.

As long as a column adjacent(left or right) has values, d-click will copy
down to end of non-blank data in that adjacent column.

i.e. Column C has data to row 40

In B1 enter =C1

D-click on B1 fill handle to fill down to B40.

Note: d-click will default to left adjacent column if both left and right
adjacent columns have data.

You must have "allow cell drag and drop" enabled.


Gord

On Fri, 6 Feb 2009 22:42:01 -0800, Khoshravan
wrote:

I am using Xl2003 but d-clicking the fill handle does not work in my XL. Does
it need to be activated some where in the XL?

How to copy a cell and horizontally expand the paste along hea
 

Ok, Gord. Thx for the reply.

Too bad there isn't any solution, it could have been very helpful.

Cheers,

al7riv



"Gord Dibben" wrote:

Double-click to fill only works filling down, not across.

You have to use some other method of copying across.

I know of no way to simulate the d-click filldown using the keyboard.


Gord Dibben MS Excel MVP

On Fri, 6 Feb 2009 12:46:01 -0800, al7riv
wrote:

Hi all,
I know how to do this action on a vertical way:
- Prerequisite: the first column is filled in on 10 rows high;
- Select the top cell of the second column;
- Double-click on the black bold cross in the lower-right of this cell.
As a result, the content (for instance, a function) of the selected cell is
pasted downward alongside the first column, until the end of it (and no
more).
Now the question: how can we perform this action on an horizontal way (first row filled in on 10 columns long and select/double-click the leftmost cell of a second row alongside the first row)?
A helpful answer would be really appreciated!! ;-)
By the way, in case you know how to perform these 2 actions without using
the mouse, I take it as well :-)
Thx in advance for any kind of help,
Bye

Hi,

Although it is a very old thread - here is a Macro which will emulate a Horizontal double-click Fill-in:

Michael (Micky) Avidan
“Microsoft®” MVP – Excel
ISRAEL