> > > > 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. > And that shortcut is [alt]+[enter], as Regina mentioned (thanks) in a prior email in this topic thread.
>From the useful: [url] https://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets [/url] [quote] To fill a selected cell range with the formula that you entered on the Input line, press Alt+Enter. [/quote] So instead of: A1 => 1965 [Enter] B1:AX1 => formula(=A1+1) [Control+Enter] in Calc you do: A1 => 1965 [Enter] B1:AX1 => formula(=A1+1) [Alt+Enter] BTW, there is a _very limited_ document regarding LibreOffice and MSOffice (including Calc and Excel): [url] https://wiki.documentfoundation.org/Feature_Comparison:_LibreOffice_-_ Microsoft_Office [/url] Regards, Ady. -- To unsubscribe e-mail to: [email protected] 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
