To do that, open the Macros window, select the macro, and click Options. Under Shortcut key, press the key to use with Ctrl —I chose Ctrl + J —and click OK. When choosing the key, just make sure it ...

Excel formulas are powerful, but they have their limits. I used to rely on complex nested formulas that take forever to build and are difficult to troubleshoot, but I have started leaning more heavily ...