> > I don't remember whether there is a simple keyboard shortcut to > simultaneously insert the same value/formula in multiple cells in > Calc. I'd like to clarify the above paragraph. One thing would be to insert "the same" value/formula simultaneously in multiple cells. A more powerful keyboard shortcut would be to:
1_ Select a range of cells; 2_ Type in a formula; 3_ Press a combination of keys that would: 3.1_ insert the typed in value/formula in the first cell of the selected range, and then; 3.2_ would "extend", or "fill in", or "copy+paste" the first cell to the rest of the cells in the selected range. If the typed in formula would be "=A1+1" (without quotation marks), then: A_ the "same formula" would mean the _exact_ same formula, as if it would be copying the content of the cell (as oppose to copying the first "cell"; or B_ copying the first formula while respecting relative references too (e.g. "=A2+1" ; "=A3+1"; ... ) Whether case "B" would also copy the entire first cell (including formatting) into the rest of the selected range would be something to consider if/when such shortcut gets to be considered for development in Calc. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
