Edit in grid view option missing in a Modern SharePoint view

Edit in grid view option will not be displayed for a particular view because of multitude of reasons. Some of the popular reasons were

  1. Adding Groupings
  2. Using supported browser
  3. Not having enough access on the list/library

Here is one more interesting addition to the above list. When a view is edited and set to have any different display Style other than ‘Default’ Edit in grid view option will not be displayed. 

Microsoft may fix this limitation in future. As it stands today, if a view is set to have any other display Style other than default, Edit in grid view option will be unavailable.

Resolution: To get the Edit in grid view option back, set the display style back to Default.

8 thoughts on “Edit in grid view option missing in a Modern SharePoint view

  1. The “Edit Grid” view (or legacy DataSheet view) is not an option when creating a new view. The only options are List, Calendar and Gallery. How can I make the default view a Grid view?

  2. Hi Rothmann,
    Try creating new view from Gear icon (settings) -> List settings -> Scroll all the way down to Views -> Create view. You will find the ‘Data sheet view’ option available there. Thanks.

  3. Edit in grid view is getting hidden, if you format the view, so create again new view dont format then the
    “Edit in grid view” will appear

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SharePoint Navigation switcher

SharePoint Navigation has received lot of attention in the past couple of year when compared to how users had to deal with navigation in SharePoint 2010 & 2013 On-prem days. Here is the latest of the improvements, SharePoint navigation switcher. This feature was made Generally available in Dec 2021. By the time of this writing […]

Read More

Disable feedback surveys in Power Platform

If you have worked in Microsoft 365 PowerApps or Power Automate, you might be familiar with feedback survey which pops up quite often. Microsoft wants your feedback on how likely are your to recommend Power Automate to a friend or colleague? Well, I ran into a conversation in twitter about this survey. Apparently I learnt […]

Read More

Missing a column in SharePoint list/library filter pane

Missing a column in SharePoint list/library filter pane? It is normal. Not all columns are available in the filter pane by default. What is filter pane? Filter pane is available in the top right hand corner in list or library page. It is available by clicking on the funnel icon. Filters available are based on […]

Read More