RE: [users] Calc: Insert 25 blank linesI may be missing something, here, but it occurs to me that, after admittedly a bit of work, you could create a macro to accomplish the task, whichever method or workaround you chose, and 'get the job done' with a minimum of manual keyboard/mouse labor. The macro could be assigned to a keyboard combo, such as <CTRL><SHIFT>I (for "Insert"), no?
This is my first posting/opining, and apologies are offered if I've stepped out of line... - Ken -----Original Message----- From: Dotan Cohen [mailto:[email protected]] Sent: Saturday, January 31, 2009 7:13 PM To: [email protected] Subject: Re: [users] Calc: Insert 25 blank lines 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. Thanks. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת ا-ب-ت-ث-ج-ح-خ-د-ذ-ر-ز-س-ش-ص-ض-ط-ظ-ع-غ-ف-ق-ك-ل-م-ن-ه-و-ي А-Б-В-Г-Д-Е-Ё-Ж-З-И-Й-К-Л-М-Н-О-П-Р-С-Т-У-Ф-Х-Ц-Ч-Ш-Щ-Ъ-Ы-Ь-Э-Ю-Я а-б-в-г-д-е-ё-ж-з-и-й-к-л-м-н-о-п-р-с-т-у-ф-х-ц-ч-ш-щ-ъ-ы-ь-э-ю-я ä-ö-ü-ß-Ä-Ö-Ü -------------------------------------------------------------------------------- I am using the Free version of SPAMfighter We are a community of 5.9 million users fighting spam. SPAMfighter has removed 2409 of my spam emails to date. The Professional version does not have this message
