Update information at the speed of type: Edit in grid view
Published Feb 02 2021 08:00 AM 44K Views
Microsoft

The new Microsoft Lists grid view is now available worldwide, including SharePoint lists and libraries that share the same technology platform in Microsoft 365.

 

With simple, inline experiences, you can quickly update your information or add new items easily. Features like drag to fill, undo/redo, new field editors (text, date, people, yes/no, choice), and copy/paste make grid view the best place to get your information, quickly and organized.

 

We’ll cover all new features and capabilities below – including screenshots and links to learn more, starting here with an in-depth demo video I produced to showcase all the goodness our Lists engineers have been working on and refining:

 

 

Let's dive into the details...

 

The ‘Quick edit’ button is now ‘Edit in grid view’

Previously, when users bulk edited list items in a list or a document library, they select the Quick edit button in the top action bar. We are renaming Quick Edit to Edit in grid view.

 

The Quick Edit button for all lists and libraries in Microsoft 365 will be renamed “Edit in grid view” [bottom]; previously “Quick edit” [top].The Quick Edit button for all lists and libraries in Microsoft 365 will be renamed “Edit in grid view” [bottom]; previously “Quick edit” [top].

The newly named view provides an inline editing experience with lots of improvements, making it easy to quickly update list items in bulk within grid view. We’ll cover all of this beyond the button rename below.

And, if you love grid view, make it your default view. That's right, you can save a view in grid for any SharePoint list or document library. Note: when a user saves a view in Quick Edit, the list or document library will always render in quick edit for easy inline editing.

Edit with confidence, for those accidental ‘oops’ moments

As you work across rows and columns within Microsoft Lists, mistakes will happen, and it needs to be easy to recover information. Like how you can remove sentences and phrases in a Word document, you will be able to do this in Lists by using the undo button. The same is true in reverse if there was something in a field previously that you want to bring back - just click the redo button.

 

Click Undo or Redo to revert changes or remove mistakes within Microsoft Lists.Click Undo or Redo to revert changes or remove mistakes within Microsoft Lists.

Improved inline editing experience

The team has been working hard to improve the inline editing experience and release the new grid view. Our priority is providing the most effective inline editing experience by delivering new field editors and features designed to make editing data better than ever.

 

New inline field editors

Person

Items with a Person column can now be rendered using the new "pill" design format with a profile person’s photo also displayed. Select one or more people to add to a Person column quickly, and the entry will display an updated look. To turn this on, you can select “show profile picture” from the column setting.

 

Roadmap ID: 67095

person.png

 

Show profile photos.png

Choice

Items within a Choice column will support single, multi-choice, and manual fill as you add items. You'll see updated formatting right away and can update and remove choice fields and formatting selections previously applied.

 

Roadmap ID: 67095

pending nterview.png
Date and Time

The legacy calendar control is replaced with Office Fabric calendar for Gregorian calendars in SharePoint lists and libraries when filling or adjusting the date field. The new calendar experience is faster and delivers a coherent experience across throughout.

 

Roadmap ID: 63277

date and time.png
Yes/No

Items with a Yes/No column will appear with a check mark when the value is selected.

 

Roadmap ID: 67119

YN.png
Multi-line Rich text editor

When you turn on rich text editing in your multi-line text fields, you can now edit directly inline in grid.

 

Roadmap ID: (coming soon)

multiline text editor.png

 

Improvements to the overall editing experience throughout the grid

As you can see, what was ‘Quick edit’ is now Edit in grid view, and one of the biggest innovations is simply improving the speed and accuracy for how you input and update information. The grid itself is a feature, and we’ve spent a lot of time reviewing feedback and improving both technology and performance – to keep up with the speed at which you work AND not slow you down.

 

The new Quick Edit experience showing some of the innovation: updated grid lines, fixed row height, new selection, sticky first column, Add new button, visual cues and more.The new Quick Edit experience showing some of the innovation: updated grid lines, fixed row height, new selection, sticky first column, Add new button, visual cues and more.

Fixed row height | When in grid, you will see a new layout option “Fixed Height” within the view drop-down menu. This layout option will adjust the height of all rows to the same height to optimize vertical spacing.

row height.png

Sticky first column | Easily navigate you list with a sticky column. As you scroll horizontally across a list or documentary library in grid, the far-left column remains in place. You can see this in the main graphic of this section – the “Session name” column remains in place as you scroll to the right.

New Visuals | You'll see new grid lines, an improved on-hover experience when using your mouse around the grid, themed color bars on the side of list items - including error messaging, a “Create New Item” button at the bottom of quick edit for creating new items inline, and updated column header drop-down menus.

Selection | You will see an updated way for selecting single or multiple items. This, too, supports existing copy/paste and drag-to-fill, applicable to multiple rows when using shift + selection. And when navigating and interacting via keyboard keystrokes - like what we talked to John Sanders about - a consistent keyboard navigation approach.

Expanding the default grid view from 30 items to 100 | You will now see 100 items per page on SharePoint document library or list when using Quick Edit; aka, less need page through items - noting that many lists are greater than 30 items and less than 100 - a nice data-driven outcome based on real customer use.

Keyboarding consistency | When you edit in grid view, you will have a faster editing experience that adheres to greater levels of accessibility. Navigate across rows and columns using the tab key. Plus, pressing Enter enables you to edit that field. Clicking Enter on a new row saves the new item. And pressing the Esc key closes editor.

Visual and verbal read only field cues | Lists fields will show people when a field is edit-only and screen reader support when a field is read-only.

Configure your schema, aka – make lists your own especially when in grid view

You no longer need to leave inline editing to configure schema on your list – to do things like filter, sort, create new columns, hide columns, and save views… yep, do all that now directly from grid edit mode.

 

Create all column types directly from Quick Edit | You’ll be able to create all the same columns types when you need to start tracking additional information without have to leave Quick Edit.

Create all column types directly from Quick Edit.Create all column types directly from Quick Edit.

Learn more how to create all column types when in Edit in grid view mode.

 

Edit all columns directly from grid | The capabilities when in Lists "grid" view will now allow people to pin a column to the filter's pane, format the column, show/hide columns, and hide their column(s). You used to have to exit out of grid edit to accomplish these common tasks. Exit edit mode less – that’s the new motto.

Access list forms while editing in grid view

We have brought the form into grid view so you can easily view your content vertically or create new items. This is useful if certain columns are hidden from the view or you have lots of columns requiring horizontal scrolling.


View and edit items in forms inside of grid | Get full visibility on the whole of information per list or file item by viewing its form (instead of scrolling to the right on the row).

 

View and edit items in forms inside of Quick edit.View and edit items in forms inside of Quick edit.

“New” button on the command bar | Alongside adding a new row below the last, you can now click the New button to add a new item or file – the same “New” experience when not in Quick Edit.

Learn more about editing list items.

 

In summary…

So, go ahead, Edit in grid view. We know you’re going to like the depth of capability when in edit mode, including the performance and bulk capability improvements.


To learn more about lists, check out the additional resources:

Track what matters most. Make a list and let it flow.

 

Thanks for checking out the new grid view,

 

Miceile Barrett, senior program manager – Microsoft (@MSFTmiceile on Twitter)

21 Comments
Copper Contributor

Love the new grid view.  Bulk copy from the grid view works great on a PC but not so much on a Mac yet.  Is that also on the roadmap?

Brass Contributor

SharePoint choice columns you used to be able to copy paste a line break separated list of items. The new UI makes adding choices a very tedious process :crying_face:

Brass Contributor

Hi, I find it difficult to delete rows in grid view. If I paste a datasheet and edit row by row, and then find a row which doesn’t fulfill a column validation and can’t be saved, then I am unable to delete the row and it prevents the following rows from being saved.

Copper Contributor

It's been great to see the development you're putting into Lists! I have noticed one bug with the "Edit in grid view" keyboard functionality. When logged in with a user with Full Control I can tab through all of the columns when in "Edit in grid view" mode. However, when I am logged in with a user with Contribute / Edit permissions, it skips the last column / cell and moves onto the next line. Can you let me know where to file an issue report, if not here?

Copper Contributor

I have tried using grid view and nothing saves.  Please help.

Copper Contributor

@Miceile Barrett ,

 

I am unable to edit image-type of cells in grid view.  Is this a known issue? Or I am doing something wrong?

 

Thanks a lot in advance for your help and support.

 

kaanersoy_0-1617885115062.png

 

Copper Contributor

Have a list with 700 resumes in it. I want to note which resumes have the word " Azure " in them with a yes or no in the HasAzure column. I can search the resumes easily, but I can't flip the search results into grid view and add "yes" to the ones that have the keyword. 

Copper Contributor

WIll the Grid-view be available on mobile?
Specifically in the SharePoint App and in the Browser?

 

Blessings Michael

Brass Contributor

Type-ahead lookup fields do not work in any of the mobile versions of lists. 

 

I have a column that is a lookup to a second column. When I click on the empty field, the entire list of choices shows up, but the moment I start typing, it goes empty and finds no matches. 

Copper Contributor

hello - is there some explanations why everything is slowing down as soon as editing in grid view -  same with json formatting as well - i had to delete everything + go back to normal view - same issue in lists by the way  - any idea how to fix this ? thanks so much

Copper Contributor

Hi there, 

In the last few days we are having issue using grid view. Users can edit any properties of any documents. It used to work fine.

 

grid 1.PNGGrid.PNG

Kind Regards 

 

Copper Contributor

Hello @Harris0261 

 

This exact same error has just appeared for our site today. I have tried it with a number of lists and it still fails.  I have added an additional field and tried to edit other fields that are not person fields and it still will not let me enter data into the field in grid view. It works perfectly fine editing one record at a time.

 

See below. As soon as I enter data into the Office only column the red exclamation mark appears at the beginning of the row.

 

Have you found a solution?

 

Can anyone suggest a solution please?

 

Thank you

 

Anton

 

atoma15_0-1631769038559.png

 

Copper Contributor

Hello @atoma15 

 

I am still struggling to find the fix. I have four documents library with the same columns, and I have an issue with two of them.
I have tried the below steps and still having the issue:

 

  1. disable and enable quick view in library settings
  2. Remove all the mandatory fields 
  3. Making sure the view is on default view

Kind Regards 

Copper Contributor

Hi @Harris0261 

 

Yes no luck here except I did notice that the problem does not occur on the ALL ITEMS view, so I created a new view by copying ALL ITEMS and called it Admin View New and that enables the user to enter data using the grid view and it saves the data correctly.

 

I hope that helps.

 

Anton

Copper Contributor

Hi @atoma15 

 

Thanks for sharing. I believe you are working on the SP list, and I am working on the document library. I have followed your suggestions, and I am still having the issue.

 

Kind Regards 

Copper Contributor

When I share the list, the user with edit rights cannot see the grid mode ?

Copper Contributor

I am new to this community.
I have about a 2,000 item list that I am editing in grid view.  Is there a way to get to the bottom of the list quickly instead of scrolling down and advancing one screen at a time with the arrow?

Copper Contributor

@April7777 include and show the ID column in your view, and sort the view by it in descending order as required, or set up a new view with that specific order that you can switch to when needed.

Use sorting to modify a SharePoint view (microsoft.com)

 

Copper Contributor

Would like to understand why Thumbnail Preview does not display in Edit in grid view in assets library yet I can see from screenshots 'Picture' displays. Is this a list feature only?

Copper Contributor

I'm having similar issue, Edit in Grid View options is available in Web List but its not showing Microsoft List Client.. its tricky.. there is any solution for this ?

Copper Contributor

Hello, I am using MS Lists. I have created folders and moved the list items into the relevant folders. Due to GDPR I only want to share certain information with specific people hence the folders, however I would still like to visualise all the data.

The issue is; when I share a folder ideally we would like the recipient to edit in grid view making it faster for them to fill in the cells/columns requested. I have tried to resolve this but can't quite get there!

Any help would be appreciated :)

Thank you

Version history
Last update:
‎May 06 2021 11:44 AM
Updated by: