(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?