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
_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
