Forum Discussion
Limit rows when opted Edit in grid view in Lists
ramanjineyulur When you open a SharePoint list in Grid view, by default it opens with paging of 100 items.
You can scroll to the bottom and use Add new item option to add more items. So, you have to scroll up to 100 items only and not 1000+ items:
Also, I don't think there is any SharePoint out of the box setting/option to change this limit of page items (100) in grid view.
You can try this workaround:
- Create a new view in SharePoint list
- Modify view settings and applying filters so that it will have less number of items
- Open newly created list view in grid view to add more items
Example: I used these view settings to have only one record in list view:
As it shows only one item, no need to scroll down:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- ramanjineyulurNov 13, 2023Copper Contributor
Thank you ganeshsanap , the 2nd solution is working as filtering then adding data, but limit of 100 rows not yet found the solution, I keep scrolling and its keeps expanding the rows