Sharepoint Lists filter by number - slider option?

Question

Hello

I am currently working on Sharepoint List and one of the columns I am working on of type number.

I have set the minimum value of this column to be 0.

I created a few rows with some numbers and then I attempted to filter by this column. But I realized that I had to click each number one by one.

My question is: Is there an easier way to filter by number that does not require me to click everything one by one.

For example if I have 250 values, then to find things that are less than 100 would require me to click at least 99 boxes times.

Clicking that many times does not make sense. I estimate that the possible range of values that I would have would exceed 1000.

Answer 1

Dear @E L,

Good day, and thank you for sharing the details of your scenario.

I understand what you mean. If a number column has many possible values, selecting each checkbox one by one from the SharePoint List filter pane is not practical, especially if the range may go above 1,000.

As a forum moderator, I genuinely wish I could check your list settings directly and confirm the available options in your environment. However, I do not have access to your tenant or backend settings, so I can only provide general guidance based on SharePoint Lists behavior.

From my research, the standard SharePoint/Microsoft Lists filter pane does not provide a slider-style number filter like Excel. The checkbox filter is mainly designed to select existing values. For numeric range filtering, the better approach is to create or modify a view and use conditions such as is less than, is greater than, is greater than or equal to, etc. You can try this approach:

• Open your SharePoint List.
• Select the current view name, for example All Items.
• Choose Edit current view.
• Scroll down to the Filter section.
• Select Show items only when the following is true.
• Choose your number column.
• Set the condition, for example: is less than or equal to 100

• Save the view.

You can also create multiple saved views for different ranges if needed, such as one view for items under 100, another for 100–500, and another for values above 500.

If your list is large, especially near or above the SharePoint List View Threshold, it is also a good idea to index the number column used for filtering. This may help improve filtering performance and reduce issues when working with larger lists.

I hope this information helps clarify the situation and provides you with workable solution. Should you have any further questions or need additional assistance, please don't hesitate to reach out. I'm always happy to help. Have a wonderful day! 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.