On 01/02/2009 01:38, Brian Barker wrote:
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
The first row row be selected should be the one above which the [new]
empty rows are to go. This row is included in the count of new rows. So,
for example, to insert 10 empty rows between rows 1 and 2, select rows
2-11 inclusive (10 rows), right click and choose Insert Rows. The rows
you select don't need to be empty, contrary to my earlier statement - sorry.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
