On Fri, 06 Jun 2008 17:23:40 +0100 Brian Barker <[EMAIL PROTECTED]> wrote:
> At 12:00 06/06/2008 -0400, Jerry Feldman wrote: > >... but what if I want to add 400 rows, In the real spreadsheet I > >have I need to extend the sheet by 400 rows. Insert rows or cells > >would require a lot of work. > > Not necessarily: > o Click the row label to select the first row that you need to move > down to make space for your new rows. > o Scroll down sufficiently that you can see the last row that will > be replaced by your new rows. > o Shift-click its row label, so that you extend the selection to > include all the rows that will need to be moved. > o Go to Insert | Rows (or right-click - in the row labels | Insert > Rows). Sufficient new rows are created to replace the selected rows. > > I trust this helps. Thanks Brian. That did the trick. Now, how do I get actuary spreadsheet authors to put algorithms in macros rather than in spreadsheet cells :-) -- -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
