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
|