You can assign a keyboard shortcut to Excel macros written in VBA code, just as you can with recorded macros. Since you're using macros to save time, triggering them with keystrokes is a great idea.

Locate the sheet whose columns you want to adjust automatically, and right-click the sheet tab at the bottom of the Excel window. Then, click "View Code." In the VBA window, select "Worksheet ...