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 ...