Re: [libreoffice-users] User interface: [cntl-F2] in Calc

You should be able to assign these actions to any available shortcut key.

Looking at the existing bindings, Ctrl+F2 is listed as "Function" and 
Ctrl+/ is "Select Array Formula".

Both of these actions are available under the "All Commands" category 
(Function is in the Insert category and Select Array Formulas is in Edit).

Select the desired Shortcut Key at top and desired Function at bottom 
then click the Assign key.  No reason it shouldn't work unless it 
conflicts with some shortcut from your operating system.  You can 
replace existing shortcuts if it's something you never use.

Be sure to do this from a Spreadsheet, the bindings are different for 
each module (Calc, Writer, Draw, etc).

The grayed out keys can't be assigned because they are used by some 
system-wide shortcut.


On 9/15/26 04:37, David Lynch wrote:
> With the increased selection of array functions in Calc, I am needing to
> [cntl-/][cntl-F2],frequently.
>
> Can I configure Tools -> Customise -> Keyboard, to replace
> [cntl-/][cntl-F2] with a single key stroke?
>
> Currently [cntl-F2] with a cell containing an array function spilling into
> other cells does nothing. Are there any problems arising if the behaviour
> is changed to that of [cntl-/][cntl-F2] currently?
>
> If not, I will make an enhancement request.
>
> David Lynch

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy