Launch Microsoft Excel and open the file in which you want to insert VBA code to control cut and paste operations. Click "File" on the Excel ribbon, then "Options" at the bottom of the menu.

Step 1: Open VBA 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." ...

Open an Excel workbook on your PC. Press the Alt + F11 (or Option + F11 for Mac) keys to open VBA. Alternatively, you can head to the Developer tab and select Visual Basic.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.