At 07:23 02/01/2008 -0700, Timothy Lipp wrote:
Is it possible in Calc to insert a row that has the same formatting
and formulas as either the row above or below it? Basically so it
copies everything except data into a new row.
Is it a bird? Is it a plane? No: it's Paste Special!
o Copy the relevant row or cells.
o Go to Edit | Paste Special... (or right-click | Paste Special...
or Ctrl+Shift+V).
o In the Paste Special dialogue, untick "Paste all" if necessary and
make sure that Numbers is not ticked (and Text?) but that Formulas
and Formats are ticked.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
