How to Show All Items in Grouped SharePoint List Views
Question details
The user needs to make a grouped SharePoint list display all entries in each group instead of showing only about 30 items with a Show More or Show All link.
- Product
- Microsoft SharePoint list views
- Device & OS
- not provided
- Scenario
- A grouped SharePoint list view has a higher item limit, but each group initially renders only about 30 items.
- Observed behavior
- Grouped sections show about 30 items followed by Show More or Show All even when the view item limit is set to 1,000.
Confirm that you have permission to edit the SharePoint list view, and check whether the list is using the modern or classic SharePoint experience before changing settings.
Remove grouping or switch to an ungrouped view to show all items
Use this when you need all list items visible on one page without selecting Show More inside each group.
Open the SharePoint list and click the view name dropdown, then choose Edit current view.
In the Group By section, set the first grouping field to None or select an ungrouped view.
Under Item Limit, set the number of items you want the view to display, such as 1000.
Click OK, refresh the list page, and verify that all items appear without a Show More link.
Test the grouped view in modern and classic SharePoint experiences
Use this if you must keep grouping and want to confirm whether the 30-item display behavior is specific to the modern SharePoint experience.
Use WPS Office as a Free Alternative for SharePoint and Office File Tasks
SharePoint list view grouping is a Microsoft SharePoint setting and cannot be changed by WPS Office. WPS Office is a free, lightweight alternative for editing the Word, Excel, and PowerPoint files you store or download from SharePoint, with full Office format compatibility and a familiar interface.
- 1. Download WPS Office: Download WPS Office free from the official WPS website.
- 2. Install WPS Office: Install WPS Office on your Windows or macOS device.
- 3. Open a SharePoint file: Open a Word, Excel, or PowerPoint file downloaded from SharePoint.
- 4. Edit and save: Edit and save the file; WPS preserves Microsoft Office format compatibility.
Frequently Asked Questions
Why does my grouped SharePoint list view show only about 30 items even though the item limit is set higher?
In modern grouped views, the initial number of items rendered inside each group is separate from the view item limit. Edit the view and review the grouping settings, or remove grouping and use an ungrouped view.
How do I remove grouping from a SharePoint list view?
Open the SharePoint list, click the view name dropdown, select Edit current view, find the Group By section, set the first grouping field to None, and click OK.
Does increasing the SharePoint view item limit make grouped sections show all items?
Not always. The item limit controls the total number of items in ungrouped views, but grouped sections may still show a reduced batch with Show More, especially in the modern experience.
Is there a way to force Show All as the default in every SharePoint group?
SharePoint does not provide a guaranteed tenant-wide toggle to force Show All in every group. Test classic experience or use an ungrouped view, and consider submitting feedback through SharePoint UserVoice.
