Forum Discussion
Limit rows when opted Edit in grid view in Lists
Hi,
I have some list which having more than 1000 rows, if I have to add the data using edit in grid view, I need to scroll down until 1000+ rows completes, is there any option to restrict the rows when we choose this option?
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.
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
