Home
%3CLINGO-SUB%20id%3D%22lingo-sub-778186%22%20slang%3D%22en-US%22%3EEnhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778186%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20need%20to%20streamline%20business%20processes%2C%20you%20need%20great%20tools%20to%20edit%20data%20in%20lists%20and%20libraries.%26nbsp%3B%20Excel%20has%20long%20been%20a%20foundational%20tool%20for%20collecting%2C%20editing%20and%20analyzing%20data.%20People%20understand%20and%20embrace%20the%20simplicity%20of%20sorting%20and%20editing%20data%20values%20in%20a%20grid.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20we%20announced%20at%20SPC18%2C%20we%20are%20pleased%20to%20finally%20release%20our%20enhanced%20Quick%20Edit%2C%20bringing%20the%20power%20and%20simplicity%20of%20%E2%80%9Cspreadsheet%E2%80%9D%20views%20to%20modern%20SharePoint%20lists%20and%20libraries.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20preview%20the%20new%20Quick%20Edit%20in%20this%20%3CA%20href%3D%22https%3A%2F%2Fdemobuilderwebcpptxz.blob.core.windows.net%2Fquick-edit-for-lists%2Fstartdemo.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eself-service%20walk%20through%3C%2FA%3E.%26nbsp%3B%20%26nbsp%3BLet%E2%80%99s%20look%20in%20more%20detail.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%20id%3D%22toc-hId-1794460911%22%3EFilters%20Pane%20is%20now%20available%20in%20Quick%20Edit%20Mode%26nbsp%3B%26nbsp%3B%3C%2FH2%3E%0A%3CP%3EUsers%20can%20filter%20their%20content%20in%20Quick%20Edit%20mode%20to%20locate%20the%20items%20for%20updates.%20In%20addition%2C%20any%20filters%20or%20sorting%20applied%20in%20Quick%20Edit%20will%20persist%20as%20the%20user%20navigates%20back%20to%20the%20normal%20view.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124857iB5500C2818C549B8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22QE1.png%22%20title%3D%22QE1.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFiltering%20in%20Quick%20Edit%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%20id%3D%22toc-hId--757696050%22%3EAll%20formatting%20appears%20in%20Quick%20Edit%26nbsp%3B%26nbsp%3B%3C%2FH2%3E%0A%3CP%3EAny%20custom%20formatting%20for%20the%20list%20or%20document%20library%20will%20now%20also%20render%20in%20Quick%20Edit.%20For%20example%2C%20this%20includes%20experiences%20like%20row%20formatting%2C%20user%20profile%20photos%2C%20conditional%20formatting%2C%20and%20data%20bars.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124859iE46505D8E007EF16%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22QE2.png%22%20title%3D%22QE2.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFormatting%20in%20Quick%20Edit%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%20id%3D%22toc-hId-985114285%22%3EBreadcrumb%26nbsp%3B%26nbsp%3B%3C%2FH2%3E%0A%3CP%3EJust%20as%20in%20normal%20list%20and%20document%20library%20views%2C%20the%20breadcrumb%20will%20now%20appear%20in%20Quick%20Edit.%26nbsp%3B%20This%20gives%20you%20a%20visual%20clue%20about%20applied%20filters%20and%20a%20simple%20way%20to%20navigate%20%E2%80%9Cback%E2%80%9D%20to%20larger%20data%20sets.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124860iDC3E6A1B03CCAE3B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22QE3.png%22%20title%3D%22QE3.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EQuick%20Edit%20breadcrumbs%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%20id%3D%22toc-hId--1567042676%22%3EAdjust%20and%20save%20column%20widths%26nbsp%3B%26nbsp%3B%3C%2FH2%3E%0A%3CP%3EUsers%20can%20now%20define%20their%20preferred%20column%20widths%20by%20dragging%20and%20dropping%20directly%20within%20Quick%20Edit.%20In%20addition%2C%20any%20previously%20save%20column%20widths%20(either%20in%20the%20view%20or%20in%20local%20storage)%20will%20persist%20for%20users%20when%20they%20navigate%20to%20Quick%20Edit.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%20id%3D%22toc-hId-175767659%22%3EDrag%20and%20drop%20columns%3C%2FH2%3E%0A%3CP%3EEasily%20re-order%20your%20columns%20within%20Quick%20Edit%20by%20dragging%20and%20dropping.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124861i0B4563F40F67B2CB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22QE4.png%22%20title%3D%22QE4.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EDrag%20and%20drop%20columns%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%20id%3D%22toc-hId-1918577994%22%3EEnhanced%20people%20picker%3C%2FH2%3E%0A%3CP%3EYou%20can%20now%20browse%20and%20selected%20users%20from%20your%20organization%20directory%20efficiently%20with%20our%20new%20people%20picker.%26nbsp%3B%20You%20can%20browse%20for%20partial%20name%20matches%20and%20see%20user%20photos%20and%20titles%20in%20line%2C%20as%20shown%20below.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20305px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124862iAEAA33CC40343D01%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22QE5.png%22%20title%3D%22QE5.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EEnhanced%20people%20picker%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EQuick%20Edit%20enhancements%20will%20start%20rolling%20out%20to%20Targeted%20Release%20in%20July%202019.%20%26nbsp%3B%26nbsp%3BWe%E2%80%99ll%20continue%20to%20share%20the%20latest%20news%20here%20on%20the%20TechCommunity.%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-778186%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20pleased%20to%20finally%20release%20our%20enhanced%20Quick%20Edit%2C%20bringing%20the%20power%20and%20simplicity%20of%20%E2%80%9Cspreadsheet%E2%80%9D%20views%20to%20modern%20SharePoint%20lists%20and%20libraries.%26nbsp%3B%20%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124855i86AF4B424080129D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22QE1.png%22%20title%3D%22QE1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-778186%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EProduct%20Updates%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781165%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781165%22%20slang%3D%22en-US%22%3E%3CP%3EI%20like%20the%20way%20of%20using%20interactive%20demo%20to%20introduce%20new%20features.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781502%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781502%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20very%20useful!%20Keep%20up%20the%20great%20work!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782496%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782496%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20List%20experience%20is%20in%20Modern%20Experience%2C%20Data%20Sheet%20View%20is%20showing%20as%20Standard%20view.%20If%20List%20experience%20is%20in%20classic%2C%20Data%20Sheet%20is%20working%20fine.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAnyone%20facing%20the%20same%20issue.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782909%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782909%22%20slang%3D%22en-US%22%3E%3CP%3EExcellent%2C%20It's%20a%20great%20news%20and%20I'm%20really%20excited%20to%20use%20this%20features.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fstareyes_40x40.gif%22%20alt%3D%22%3Astareyes%3A%22%20title%3D%22%3Astareyes%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783029%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783029%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20feature!%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fstareyes_40x40.gif%22%20alt%3D%22%3Astareyes%3A%22%20title%3D%22%3Astareyes%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783920%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783920%22%20slang%3D%22en-US%22%3E%3CP%3EWow%20great%20new%20features!%20Are%20there%20any%20plans%20to%20develop%20this%20in%20SharePoint%20Server%202019%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-788557%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788557%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F98%22%20target%3D%22_blank%22%3E%40Chris%20McNulty%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWas%20there%20a%20change%20to%20the%20formatting%20of%20the%20cells%20while%20in%20Quick%20Edit%20mode%3F%26nbsp%3BWe%20are%20using%20a%20dark%20theme%20and%20I%20got%20a%20report%20today%20that%3A%3C%2FP%3E%3CUL%3E%3CLI%3Ethe%20grey%20text%20on%20white%20background%20is%20hard%20to%20read%20(see%20screenshot%20%231)%3C%2FLI%3E%3CLI%3Ethe%20formatting%20indicating%20a%20change%20was%20made%20while%20in%20Quick%20Edit%20is%20now%20a%20different%20color%20(see%20screenshot%20%232).%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRONG%3EMy%20questions%3A%3C%2FSTRONG%3E%3C%2FP%3E%3COL%3E%3CLI%3EWhat%20was%20the%20formatting%20previously%3F%3C%2FLI%3E%3CLI%3EIs%20there%20a%20way%20to%20change%20it%3F%20I%20went%20through%20all%20of%20the%20options%20to%20modify%20my%20theme%20and%20I%20can't%20tell%20what%20about%20a%20light%20theme%20vs%20a%20dark%20theme%20is%20having%20this%20effect.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ENicole%20Hill%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScreenshot%20%231%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20426px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125632i29E9EED254826742%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screenshot.PNG%22%20title%3D%22Screenshot.PNG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EScreenshot%20%231%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScreenshot%20%232%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20415px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125636i89A4B30DC86D93B0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screenshot%202.PNG%22%20title%3D%22Screenshot%202.PNG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EScreenshot%20%232%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789245%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789245%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20sounds%20cool%2C%20I'm%20always%20excited%20when%20lists%20get%20some%20love.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20the%20obvious%20question%20here%20is%20DOES%20the%20widths%20save%20after%20a%20page%20refresh%2C%20or%20can%20they%20bet%20set%20for%20all%20users%20yet%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789575%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789575%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20will%20be%20great%20-%20something%20our%20users%20rely%20on%20quite%20a%20lot.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790589%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790589%22%20slang%3D%22en-US%22%3E%3CP%3EFeature%20%22%3CSPAN%3EAny%20custom%20formatting%20for%20the%20list%20or%20document%20library%20will%20now%20also%20render%20in%20Quick%20Edit.%20For%20example%2C%20this%20includes%20experiences%20like%20row%20formatting%2C%20user%20profile%20photos%2C%20conditional%20formatting%2C%20and%20data%20bars.%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIssue%3A%20I%20am%20experiencing%20an%20issue%20where%20the%20json%20conditional%20formatting%20on%20a%20cell%20is%20not%20updating%20to%20reflect%20a%20changed%20value%20while%20in%20quick%20edit%20mode.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EFor%20example%2C%20Availability%20dropdown%20cell%20background%20is%20Green%20when%20value%20is%20set%20to%20IN.%20In%20quick%20edit%20mode%20I%20update%20the%20Availability%20column%20to%20OUT%20and%20the%20cell%20formatting%20stays%20Green%20even%20if%20I%20click%20on%20a%20new%20row%20to%20save%20the%20change.%20Its%20not%20until%20I%20exit%20Quick%20Edit%20mode%20that%20I%20see%20the%20background%20change%20to%20Red%20-%20reflecting%20the%20Out%20value.%20%26nbsp%3B%20%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-791385%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-791385%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20this%20showing%20the%20contact%20card%20when%20we%20hover%20to%20the%20user%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-792962%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792962%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20found%20that%20lookup%20columns%20no%20longer%20work%2C%20we%20can%20view%20but%20when%20trying%20to%20edit%20just%20get%20a%20loading%20icon.%26nbsp%3B%20Users%20have%20been%20switching%20back%20to%20classic%20to%20quick%20edit%20lookups.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804117%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804117%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EHow%20to%20get%20data%20into%20my%20list%20in%20the%20first%20palace%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EManuel%20edits%20and%20item%20create%20is%20simply%20not%20an%20option%20no%20matter%20how%20nice%20looking%20the%20UI%20is.%3C%2FP%3E%3CP%3E%3CSTRONG%3EI%20want%20data%20automatically%20copied%20and%20incrementally%20updated%20from%20a%22source%20list%22%20to%20my%20newly%20created%20list%20based%20on%20criteria.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESource%20list%20has%20approx%20150.000%20items%20and%20I%20only%20want%20items%20changed%20or%20created%20within%20the%20last%206%20months%20-%20approx%2030.000%20items%3C%2FP%3E%3CP%3EAlso%2C%20I%20want%20this%20transfer%2Fupdate%20to%20happen%20every%20day%20on%20an%20incremental%20basis%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20feedback%20is%20most%20appreciated%20thanks%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2F%2F%20Steen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806064%22%20slang%3D%22en-US%22%3ERe%3A%20Enhanced%20Quick%20Edit%20for%20SharePoint%20lists%20and%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806064%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F98%22%20target%3D%22_blank%22%3E%40Chris%20McNulty%3C%2FA%3E%26nbsp%3BGreat%20to%20see%20these%20features%20for%20improving%20usability!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20list%20behavior%20that's%20still%20not%20very%20usable%20is%20that%20if%20the%20list%20is%20grouped%20by%20some%20column(s)%2C%20this%20hides%20the%20Quick%20Edit%20button.%20I%20can%20sort%20of%20understand%20the%20reasoning%20logically%2C%20but%20practically%20there's%20no%20reason%20to%20remove%20this%20useful%20functionality%20for%20grouped%20lists.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20Quick%20Edit%20was%20made%20available%20even%20for%20grouped%20views%2C%20on%20clicking%20it%20the%20edit%20pane%20should%20simply%20open%20the%20list%20in%20'flat'%20mode%2C%20i.e.%20without%20the%20grouping.%20This%20would%20make%20it%20much%20more%20usable%20rather%20than%20having%20a%20grouped%20view%20solely%20for%20view%2C%20and%20having%20to%20create%20another%20ungrouped%20view%20just%20for%20editing.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

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.

14 Comments
Deleted
Not applicable

I like the way of using interactive demo to introduce new features. :smile:

New Contributor

Looking very useful! Keep up the great work!

Occasional Contributor

When List experience is in Modern Experience, Data Sheet View is showing as Standard view. If List experience is in classic, Data Sheet is working fine.


Anyone facing the same issue. 

 

 

Microsoft

Excellent, It's a great news and I'm really excited to use this features. :stareyes:

Senior Member

Great feature!:stareyes:

New Contributor

Wow great new features! Are there any plans to develop this in SharePoint Server 2019? 

Frequent Visitor

@Chris McNulty 

Was there a change to the formatting of the cells while in Quick Edit mode? We are using a dark theme and I got a report today that:

  • the grey text on white background is hard to read (see screenshot #1)
  • the formatting indicating a change was made while in Quick Edit is now a different color (see screenshot #2).

My questions:

  1. What was the formatting previously?
  2. Is there a way to change it? I went through all of the options to modify my theme and I can't tell what about a light theme vs a dark theme is having this effect.

 

Thank you,

Nicole Hill

 

Screenshot #1

Screenshot.PNGScreenshot #1

 

Screenshot #2

Screenshot 2.PNGScreenshot #2

 

 

Senior Member

This sounds cool, I'm always excited when lists get some love.

 

However, the obvious question here is DOES the widths save after a page refresh, or can they bet set for all users yet? 

 

 

Regular Visitor

This will be great - something our users rely on quite a lot. :smile:

Senior Member

Feature "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."

 

Issue: I am experiencing an issue where the json conditional formatting on a cell is not updating to reflect a changed value while in quick edit mode.

 

For example, Availability dropdown cell background is Green when value is set to IN. In quick edit mode I update the Availability column to OUT and the cell formatting stays Green even if I click on a new row to save the change. Its not until I exit Quick Edit mode that I see the background change to Red - reflecting the Out value.    

Is this showing the contact card when we hover to the user?

 

Occasional Contributor

I've found that lookup columns no longer work, we can view but when trying to edit just get a loading icon.  Users have been switching back to classic to quick edit lookups.

Frequent Visitor

How to get data into my list in the first palace?

Manuel edits and item create is simply not an option no matter how nice looking the UI is.

I want data automatically copied and incrementally updated from a"source list" to my newly created list based on criteria.

 

Source list has approx 150.000 items and I only want items changed or created within the last 6 months - approx 30.000 items

Also, I want this transfer/update to happen every day on an incremental basis?

 

Any feedback is most appreciated thanks :)

 

// Steen

Occasional Visitor

@Chris McNulty Great to see these features for improving usability!

 

One list behavior that's still not very usable is that if the list is grouped by some column(s), this hides the Quick Edit button. I can sort of understand the reasoning logically, but practically there's no reason to remove this useful functionality for grouped lists.

 

If the Quick Edit was made available even for grouped views, on clicking it the edit pane should simply open the list in 'flat' mode, i.e. without the grouping. This would make it much more usable rather than having a grouped view solely for view, and having to create another ungrouped view just for editing.