Select 'File>Save As...,' and choose 'Excel Format (.xlsx).' [PCT] How to import and create PowerPoint macros in Excel Step 1. Open Excel · Step 2. In the File menu, click 'Import…' and select 'PowerPoint (XLSX)' [PCT] Step 3. Click 'Next.' This brings you to the Power Office Ribbon. [PCT] Step 4. Under 'Tools,' click 'Add. [PCT] Step 5. In Options, click the button 'Add an Item to Workbook.' [PCT] Click Ok. [PCT] Step 6. Now, click the pencil icon located to the upper left of the ribbon. The item “Insert a macro to insert new code” appears. [PCT] Step 7. Select 'Format Macro' and then click OK. [PCT] Now the macro is added to 'Punctuation' in the Worksheet Next click 'Open Macro Library' located in the ribbon. [PCT] Step 8. The new macro is now there. [PCT] To insert it in Excel, click 'Run Macro' in the Ribbon. Then, enter the code for the macro before clicking Ok. The macro is now inserted in the Worksheet. [PCT] Step 9. The macro is now active, and it will function as you set your macro to. [PCT] [The same as step 1 & 2 in the Step 1 Tutorial] Step 10. To view the macro active window, Click on the 'Macro' drop-down menu and then select 'View Macro.