At 02:12 01/02/2009 +0200, Dotan Cohen wrote:
2009/2/1 Brian Barker <[email protected]>:
o Click to select a row or a cell within that row.
o Shift-click to select another row or cell within another row, so
as to select either a block of rows or a block of cells within
those rows. In either case, the rows need to be the rows currently
occupying the space where the new empty rows will be.
o Right-click in the selected row headers and choose Insert Rows.
I see that this way I can double the amount of cells each time. This
is a decent workaround, five iterations should get her enough rows.
It's a bit of a pain, but it works.
Sorry, but you are surely missing something here. This is not a
workaround: it's the facility that Calc provides for what you need to
do. No iterations are required. There is no pain that I can
see! Let me rephrase it:
o Select the rows where you want the new empty rows to appear (or,
if it is easier, either a column or block of cells in those rows).
o Either go to Insert | Rows or right-click in the selected row
headers and choose Insert Rows.
Job done!
Are you perhaps frightened that Calc will lose the values in the
selected rows? Trust in your friendly Calc!
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
