There are a few different ways that you can create macros in Excel. One way is to use the Macro Recorder. This is a tool that allows you to record your actions in Excel so that you can play them back later. Another way is to use VBA (Visual Basic for Applications). This is a programming language that you can use to create macros. Finally, you can use the Macro Builder tool. This tool allows you to create macros without having to write any code.
If you want to create two macros, one shortcut for each macro, then you will need to use the Macro Recorder or the VBA editor. The Macro Builder does not support creating shortcuts for macros.
To use the Macro Recorder, first turn on the recorder by clicking the "Record Macro" button on the "Developer" tab (this tab is only visible if you have enabled the Developer tab in Excel's options). Then, perform the actions that you want to record. Once you are done, click the "Stop Recording" button. You will be prompted to give your macro a name and choose where to store it. You can also specify a shortcut key for your macro at this time.
To use the VBA editor, first open the workbook in which you want to create your macro. Then press Alt+F11 to open the VBA editor. In the editor, click Insert > Module. This will insert a new module into your workbook. In the module, type or paste the code for your macro. To assign a shortcut key to your macro, go to Tools > Options and select the "Keyboard" tab. In the "Macro name" field, type the name of your macro (without quotation marks). In the "Shortcut keys" field, type the shortcut key that you want to use for your macro.