A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi,
Excel for the web appears to show roughly the first 1,000 unique items per column, and the limit cannot be changed in any setting. Desktop Excel shows up to 10,000 unique items, as listed on Microsoft's specifications page: Excel specifications and limits | Microsoft Support
You can try the following options:
- Open the file in desktop Excel: In the browser, choose Open in Desktop App from the ribbon (Editing > Open in Desktop App). The drop-down lists up to 10,000 unique items and includes a Search box for values beyond that.
- Use the filter conditions instead of the checkbox list" In the filter menu, choose Text Filters (or Number Filters) and use options such as Contains, Begins with or Equals.
- Add a helper column to group the values: For example, add a column that returns the first letter of each name, filter on that column first, then filter on the original column. Each group then stays under the limit, so every item appears in the list.
If you have any questions or need further assistance, please feel free to share them in the comments on this post.
If the answer is helpful, please click 'Yes' and kindly upvote it.
Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.