I think you name the range, and then you can do the same using ctrl+shit+L

I may not remember right, but I haves used calc and excel interchangeably since it was open office. Some things in excel drive me up the wall, some things in calc do to.

Either way, the best thing I found was get the data out of spread sheets and into something that can work with it better. Like sql or pandas.

But I get that for financial work, it is a staple. Which frightens me to no end.