Macros

Macros can be used to create commands that aren't on the menu bars of Excel.
They can be a specific command or a series of commands.
The commands I am referring to are those instructions.
They are hotkeys consisting of Ctrl's and Alt's and letters on the alphabet.
You can see the Macro option on View menu bar of Excel:

For starters on the Macro option of Excel, i'd advice you to first turn on the Relative References option for Macros.
Relative reference will make the macro not come back to its original cell where its been created.