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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 <al7riv@xxxxxxxxxxxxxxxxxxxxxxxxx>
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


.

Relevant Pages

  • RE: How to copy a cell and horizontally expand the paste along header
    ... R. Khoshravan ... "al7riv" wrote: ... the first column is filled in on 10 rows high; ... Double-click on the black bold cross in the lower-right of this cell. ...
    (microsoft.public.excel.misc)
  • RE: VLOOKUP matches
    ... Since the number in the first column are in order 1, A1+1,... ... preformatting the cell to Text ... You can not tell by checking the Format. ... random numbers from 1 to the total current number of employees. ...
    (microsoft.public.excel.misc)
  • Re: finding within an only table column
    ... each cell a word... ... Dim oCell As Word.Cell ... The Find find terms within the first column, ... but find terms within de second column too. ...
    (microsoft.public.word.vba.general)
  • Word vba Table
    ... cell content of first column on first page and copying into second cell of ... first column on second page,I extended it to copy last non empty cell ... >> Goto first page and select non empty cell from last in the first column. ... > Dim rngCell1 As Word.Range ...
    (microsoft.public.word.vba.customization)
  • Re: Removing a Row based on a cell value
    ... The example below will copy all rows with the value "Netherlands" in the first column of the range ... You can also use another cell then A1 in your table but I like to use the top left cell of the filter range that ... Dim WSNew As Worksheet ... On Error GoTo 0 ...
    (microsoft.public.excel.misc)