If you are new to macros, check out my dedicated guide below, where I go over the benefits and step-by-step instructions for creating macros in Excel.

If keyboard shortcuts are not working in Excel first check Macro settings or disable Transition navigation keys and see. More suggestions here.