Using the Command Prompt ... click "File," then "Save As." Choose "Excel Workbook (*.xlsx)" from the file type list and click "Save." To copy the list to another spreadsheet, highlight the ...

How to use VBA to highlight duplicate values in an Excel spreadsheet ... Use the downloadable .xlsm, .xls, or .cls files to obtain the code. Excel Online doesn’t support macros.