Cell selection and keyboard shortcuts on dialog box

(this may seem like a very basic question but I never found an adequate answer either here or reddit or anywhere else)
When using a default dialog box from Calc (like Pivot Table, Advanced Range, etc) I try to select a source range with keyboard shortcuts but the focus keeps switching back to the dialog box and only one cell appears as the source.

I tried named ranges but it seems dynamic ranges do not work, only static ones.

Is mouse selection the only way to select a source?

Hello and welcome abrasion599!

Do you mean input fields with a Shrink button?

With the cursor inside such fields, press F2, select cell /cell range using the keyboard and press F2 again.

1 Like

Yup.input fields with a Shrink button
a little clunky but it does work
Thank you!