Default the Power Query formula bar as on
In the Power Query editor window the formula bar is defaulted as off. This is the first thing I tell people to turn on as it’s key to avoiding unintended errors and future proofing your code.
As Gil Raviv says in his book, “ Enabling the formula bar is fundamental to avoid the pitfalls”
Again use MS Access.
Steep learning curve /////
You can program it.
Cristian Angyal commented
I am very much in favour of enabling the formula bar in PQ.