Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index




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: users+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.