From: Brian Barker [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2008 9:24 AM To: [email protected] Subject: Re: [users] Probably another stupid calc question
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. Brian Barker --------------------------------------------------------------------- Brian, I am SO grateful for this tip!!! I cannot TELL you how many times I've done exactly what Jerry described ... for decades!!! Thank you!! Elchanan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
