Sometimes there are features in Excel that there are no buttons or shortcuts for. This video shows you how to create a missing button.
No programming knowledge required, with a splash of coding info for the interested.
Using the Macro recorder, excel will write some VBA programming code to save you those annoying steps
0:00 Intro
2:36 Start the recorder
4:34 Create the Custom Button
6:59 Look at and Edit the code if you dare mwahaha
8:53 Final critical step
9:30 Thanks for watching