•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
how to select multiple values at once when filtering
Our take
Filtering a master list of 2,500 items to isolate just 150 can be time-consuming, especially when manually unchecking options. Fortunately, there is a more efficient way to filter for multiple values at once in Excel. By using the search box within the filter dropdown or applying advanced filtering techniques, you can streamline the process and save time. This approach not only enhances your productivity but also simplifies your workflow, making it easier to focus on the specific data you need. Let’s explore these methods together!
not sure if i’m wording this correctly but i work with a masterlist of about 2,500 items and i only need info for 150 of them. i’ve been clicking the drop down > unchecking “select all” > manually selecting all 150 of the items i need so that im only left with information for the items i need but is there an easier way to do this? can i somehow filter for multiple items at once? i’m pretty new to excel so i apologize if this is common knowledge
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#rows.com#filtering#excel#select multiple values#masterlist#drop down#select all#manual selection#items#info#data#new to excel#easier way#150 items