I'm trying to create a keyboard shortcut in Excel to delete the entire row containing the selected cell.
Currently, I can navigate through the menu bar to Edit > Delete, which opens a dialog box with four options. The third option ("Entire row") is the one I need to select.
My question is: how can I programmatically or via shortcuts manipulate this dialog box to select the third option and confirm by clicking "OK"?