Open the Excel workbook to the worksheet that has the list of data already entered into cells. Alternatively, type a new list of data on a worksheet; click on the default worksheet name "Sheet1 ...

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

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

If you've ever had a list of first and last names that you wanted to separate Excel and Google Sheets make it easy. Here's how to do it in each application.