Am a keen follower of Microsoft's SharePoint Blog and proud to provide this direct from the Microsoft Tech Community:

If you need to streamline business processes, you need great tools to edit data in lists and libraries.  Excel has long been a foundational tool for collecting, editing and analyzing data. People understand and embrace the simplicity of sorting and editing data values in a grid.

 

As we announced at SPC18, we are pleased to finally release our enhanced Quick Edit, bringing the power and simplicity of “spreadsheet” views to modern SharePoint lists and libraries.   

 

You can preview the new Quick Edit in this self-service walk through.   Let’s look in more detail.

 

Filters Pane is now available in Quick Edit Mode  

Users can filter their content in Quick Edit mode to locate the items for updates. In addition, any filters or sorting applied in Quick Edit will persist as the user navigates back to the normal view.  

QE1.pngFiltering in Quick Edit

 

All formatting appears in Quick Edit  

Any custom formatting for the list or document library will now also render in Quick Edit. For example, this includes experiences like row formatting, user profile photos, conditional formatting, and data bars. 

QE2.pngFormatting in Quick Edit

 

 

Breadcrumb  

Just as in normal list and document library views, the breadcrumb will now appear in Quick Edit.  This gives you a visual clue about applied filters and a simple way to navigate “back” to larger data sets. 

QE3.pngQuick Edit breadcrumbs

 

 

Adjust and save column widths  

Users can now define their preferred column widths by dragging and dropping directly within Quick Edit. In addition, any previously save column widths (either in the view or in local storage) will persist for users when they navigate to Quick Edit.  

  

Drag and drop columns

Easily re-order your columns within Quick Edit by dragging and dropping.

QE4.pngDrag and drop columns

Enhanced people picker

You can now browse and selected users from your organization directory efficiently with our new people picker.  You can browse for partial name matches and see user photos and titles in line, as shown below.

QE5.pngEnhanced people picker

 

 

Quick Edit enhancements will start rolling out to Targeted Release in July 2019.   We’ll continue to share the latest news here on the TechCommunity.  Thanks.

The above is kindly provided by the Microsoft Tech Community!