Re: non-destructive paste?

[Allin Cottrell <cottrell wfu edu>]

On Mon, 23 Sep 2013, Jean Bréfort wrote:

> Select n lines before selecting Edit/Insert/Rows, this will insert n
> rows.
>
> Hope this helps,

It does, but it seems a bit inconvenient in that you have to know n in 
advance. It would be nice to have (say) an option under Paste Special to 
do what I mentioned, i.e. create space for the pasted rows rather than 
overwriting.

Allin Cottrell

> Le dimanche 22 septembre 2013 à 17:13 -0400, Allin Cottrell a écrit :
> > This must be dead simple, but I'm not finding it via google.
> >
> > I select and copy n rows of material in sheet2 of a workbook, then I
> > switch to sheet1, use Insert to prepend a blank row, and do paste with the
> > cursor in A1. The effect is to overwrite the first n-1 rows in sheet1.
> >
> > That's what you'd want sometimes, but what I want is for the paste to
> > prepend the sheet2 data, moving the existing rows down, not overwriting
> > them. How is that done, please?
> >
> > (This is gnumeric 1.12.7.)

--
Allin Cottrell
Department of Economics
Wake Forest University, NC