Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1032576%22%20slang%3D%22en-US%22%3ESheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1032576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EHave%20you%20ever%20collaborated%20with%20someone%20else%20in%20a%20worksheet%2C%20looking%20at%20a%20large%20data%20set%2C%20and%20suddenly%20the%20table%20shrinks%20and%20you%E2%80%99re%20unable%20to%20finish%20your%20work%3F%20Often%2C%20this%20happens%20when%20someone%20adds%20filters%20to%20or%20sorts%20a%20column%20in%20a%20table%20of%20your%20worksheet.%20We%20love%20all%20the%20benefits%20of%20collaboration%2C%20but%20it%20does%20mean%20that%20when%20collaborating%2C%20everyone's%20changes%20are%20immediately%20seen%20in%20the%20document%20by%20you.%20We%20realize%20that%20our%20users%20want%20to%20collaborate%20in%20a%20document%2C%20but%20also%20accomplish%20their%20own%20tasks%20while%20sorting%20or%20filtering%20data%20in%20a%20table.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIntroducing%20Sheet%20View%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EYou%20spoke%20%E2%80%93%20we%20listened.%20Introducing%20Sheet%20View%20on%20Excel%20for%20the%20web%2C%20a%20new%20way%20of%20letting%20you%20create%20customized%20views%20in%20an%20Excel%20worksheet%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eto%20sort%20and%20filter%20your%20data%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%26nbsp%3B%20You%20can%20filter%20to%20display%20only%20the%20records%20that%20are%20important%20to%20you%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Bwithout%20being%20affected%20by%20others%20collaborating%20in%20the%20document%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%20All%20your%20cell%20level%20edits%20propagate%20through%20the%20file%20regardless%20of%20your%20view%2C%20so%20you%20can%20make%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eall%20of%26nbsp%3Byour%20in-cell%20edits%20in%20your%20Sheet%20View%2C%20too.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3ELet%E2%80%99s%20see%20it%20in%20action%3A%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%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%2F158877iCA2215DCBF67B4A9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22171609_FY20Q2_M365_APPS_Excel_Sheet_View_GIF_v05.gif%22%20title%3D%22171609_FY20Q2_M365_APPS_Excel_Sheet_View_GIF_v05.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIf%20you%E2%80%99re%20in%20the%20document%20with%20others%2C%20you%E2%80%99ll%20receive%20a%20prompt%20to%20enter%20a%20Sheet%20View%20if%20you%20want%20to%20sort%20and%20filter%20in%20a%20separate%20view.%20You%20can%20also%20create%20a%20new%20Sheet%20View%20by%20going%20to%20the%20View%20tab%20and%20clicking%20the%20eye%20icon%20labelled%20%E2%80%98New%E2%80%99.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%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%2F158914iF79B825A2CAFC3C7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3ESheet%20Views%20are%20temporary%20initially%2C%20so%20once%20you%E2%80%99re%20done%20with%20your%20work%2C%20you%20can%20choose%20to%20save%20the%20view%20to%20reuse%20later%20or%20discard%20it.%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3ETo%20discard%2C%20simply%20exit%20the%20Sheet%20View.%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3EViews%20can%20be%20accessed%26nbsp%3Bagain%26nbsp%3Bin%20the%20document%26nbsp%3Bat%20a%20later%20time%26nbsp%3Bonce%20saved.%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3EAll%26nbsp%3Byou%26nbsp%3Bneed%20to%20do%20is%20click%20on%20the%20View%20tab%20and%20find%20the%20Sheet%20View%26nbsp%3Byou%20saved%26nbsp%3Bin%20the%26nbsp%3Bdrop%20down%26nbsp%3Blist%20on%20the%20left%20side%20of%20the%20ribbon.%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAvailability%20Notes%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EWe%E2%80%99ve%20started%20the%20rollout%20to%20users%20on%20Excel%20for%20the%20web%20and%20will%20be%20available%20to%20all%20Excel%20for%20the%20web%20users%20within%20the%20coming%20weeks.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3ELearn%20More%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20title%3D%22Sheet%20View%20in%20Excel%20for%20the%20web%22%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttp%253A%252F%252Fsupport.office.com%252Fen-us%252Farticle%252F0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6%26amp%3Bdata%3D04%257C01%257Cavreddy%2540microsoft.com%257C1fea1d968fd8419a5dc808d771cf9f22%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637103008943741267%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C-1%26amp%3Bsdata%3DCc%252Bqzp1V4V4HhBYsxHf4iV348fwLOo1wMdPYPfpAtHM%253D%26amp%3Breserved%3D0%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ESheet%20View%20in%20Excel%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3Bfor%20the%20web%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20title%3D%22Learn%20more%20about%20Sheet%20View%22%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fsupport.office.com%252Fen-us%252Farticle%252F87fb6758-edbc-4cd0-bd68-76124775e9f8%26amp%3Bdata%3D04%257C01%257Cavreddy%2540microsoft.com%257C1fea1d968fd8419a5dc808d771cf9f22%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637103008943751259%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C-1%26amp%3Bsdata%3DMOE7HknGHL%252FvJvFCIwwv4hgxPgGnRsdXHrK4xRYbXhs%253D%26amp%3Breserved%3D0%22%20target%3D%22_self%22%20rel%3D%22nofollow%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ELearn%20more%20about%20Sheet%20View%3C%2FA%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3ETo%20stay%20connected%20to%20Excel%20and%20its%20community%2C%20read%20the%20Excel%20blog%20posts%20and%20send%20us%20ideas%20and%20suggestions%20via%E2%80%AF%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EUserVoice%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%20You%20can%20also%20follow%20Excel%20on%E2%80%AF%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.facebook.com%2Fmicrosoftexcel%2F%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EFacebook%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%E2%80%AFand%E2%80%AF%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fmsexcel%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ETwitter%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%E2%80%AF%20Let%20us%20know%20your%20thoughts%20on%20Sheet%20View!%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1032576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIntroducing%20Sheet%20View%20on%20Excel%20for%20the%20web%2C%20a%20new%20way%20of%20letting%20you%20create%20customized%20views%20in%20an%20Excel%20worksheet%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eto%20sort%20and%20filter%20your%20data%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%26nbsp%3B%20You%20can%20filter%20to%20display%20only%20the%20records%20that%20are%20important%20to%20you%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3Bwithout%20being%20affected%20by%20others%20collaborating%20in%20the%20document%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%20All%20your%20cell%20level%20edits%20propagate%20through%20the%20file%20regardless%20of%20your%20view%2C%20so%20you%20can%20make%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eall%20of%26nbsp%3Byour%20in-cell%20edits%20in%20your%20Sheet%20View%2C%20too.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20900px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158883iBBCED847F7BD2BAB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22171609_FY20Q2_M365_APPS_Excel_Sheet_View_GIF_v05.gif%22%20title%3D%22171609_FY20Q2_M365_APPS_Excel_Sheet_View_GIF_v05.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1032576%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECollaboration%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFilter%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESheet%20View%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esort%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1032724%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1032724%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20Feature!%20will%20this%20feature%20be%20available%20on%20the%20desktop%20version%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1033073%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1033073%22%20slang%3D%22en-US%22%3E%3CP%3E%3CI%3Ethis%20is%20amazing!%3C%2FI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1033411%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1033411%22%20slang%3D%22en-US%22%3E%3CP%3EBeing%20Excel%20on%20the%20web%20version%20only%2C%20makes%20this%20fairly%20useless%20in%20our%20org%2C%20with%20all%20its%20other%20limited%20capabilities%2C%20everyone%20here%20is%20using%20the%20desktop%20version.%20A%20certain%20amount%20of%20irony%20to%20the%20fact%20that%20Excel%20on%20the%20web%20can't%20perform%20several%20basic%20Excel%20desktop%20functions%2C%20but%20they%20jumped%20over%20those%20and%20went%20right%20to%20adding%20this.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1034859%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1034859%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F468730%22%20target%3D%22_blank%22%3E%40Avani_Reddy%3C%2FA%3E%2C%26nbsp%3Bgreat%20feature!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1039547%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1039547%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Avni%2C%3C%2FP%3E%3CP%3EI%20see%20that%20this%20functionality%20is%20available%20only%20for%20me%20in%20my%20organization%20and%20not%20others%3C%2FP%3E%3CP%3EDo%20you%20know%20why%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055970%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055970%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20should%20we%20expect%20this%20to%20show%20up%20in%20our%20organization%3F%26nbsp%3B%20I'm%20not%20familiar%20with%20the%20typical%20length%20of%20a%20rollout%20on%20the%20web.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1057025%22%20slang%3D%22zh-CN%22%3EReply%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1057025%22%20slang%3D%22zh-CN%22%3E%3CP%3Ei%20find%20the%20same%20question%20%2C%20this%20just%20work%20on%20my%20web%20client%2C%20not%20for%20the%20other%20members%2C%20why%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1057118%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1057118%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F468730%22%20target%3D%22_blank%22%3E%40Avani_Reddy%3C%2FA%3E%26nbsp%3B%20When%20I%20tested%20this%20feature%20in%20an%20excel%20file%20(shared%2C%20in%20web)%2C%20this%20feature%20is%20appearing%20for%20me%20but%20not%20for%20my%20colleagues.%20Is%20there%20any%20specific%20settings%20to%20be%20activated%20%3F%20or%20this%20feature%20is%20yet%20to%20be%20rolled%20out%20for%20all%20users%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1058063%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1058063%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20for%20a%20County%20Government%20that%20use%20Office%20365%20with%20Excel%20Online%2C%20but%20I%20do%20not%20yet%20see%20the%20sheet%20view%20included%20in%20our%20Excel%20online.%26nbsp%3B%20Is%20there%20a%20certain%20update%20or%20release%20that%20would%20include%20this%20for%20us%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1058180%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1058180%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20365%20ProPlus%20account.%26nbsp%3B%20I%20am%20using%20Excel%20for%20web%20via%20portal.office.com.%26nbsp%3B%20This%20feature%20is%20not%20available%20to%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1059861%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1059861%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20the%20ShareView%20Option%20is%20not%20available.%20How%20do%20i%20add%20it%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161073iEA223885156812AF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1060550%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1060550%22%20slang%3D%22en-US%22%3E%3CP%3EWe're%20having%20the%20same%20issue.%26nbsp%3B%20It%20works%20on%20mine%2C%20but%20not%20others%20in%20my%20org.%26nbsp%3B%20I%20didn't%20do%20anything%20to%20turn%20this%20feature%20on%2C%20it%20was%20just%20available%20one%20day.%26nbsp%3B%20How%20does%20someone%20activate%20this%20feature%20if%20it%20isn't%20showing%20for%20them%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1060552%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1060552%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F485502%22%20target%3D%22_blank%22%3E%40Bryan360%3C%2FA%3E%26nbsp%3B%2C%20you%20can%20do%20nothing%20with%20that%2C%20only%20wait%20while%20Microsoft%20activate%20the%20feature%20for%20the%20account%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1060590%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1060590%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthanks%20for%20the%20note.%26nbsp%3B%20We're%20all%20on%20the%20same%20corp%20360%20account.%26nbsp%3B%20It's%20odd%20that%20they'd%20only%20activate%20this%20for%20some%20users%20in%20an%20account%2C%20but%20not%20all%20at%20once.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1062308%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1062308%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20in%20teams%20and%20that%20is%20a%20great%20new%20feature.%26nbsp%3B%20Thanks%20for%20the%20heads%20up.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1062892%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1062892%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20not%20seeing%20this%20feature%20in%20Excel%20On%20the%20Web%20yet.%20Does%20this%20feature%20need%20to%20be%20reviewed%2Fapproved%20by%20an%20admin%20before%20it%20will%20start%20showing%20up%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1062908%22%20slang%3D%22en-US%22%3ERe%3A%20Sheet%20View%20is%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1062908%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F486772%22%20target%3D%22_blank%22%3E%40ontgov5682%3C%2FA%3E%26nbsp%3BNope%2C%20that's%20only%20Microsoft%20switch%20it%20on%20gradually.%20Please%20wait%20till%20it'll%20be%20deployed.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Have you ever collaborated with someone else in a worksheet, looking at a large data set, and suddenly the table shrinks and you’re unable to finish your work? Often, this happens when someone adds filters to or sorts a column in a table of your worksheet. We love all the benefits of collaboration, but it does mean that when collaborating, everyone's changes are immediately seen in the document by you. We realize that our users want to collaborate in a document, but also accomplish their own tasks while sorting or filtering data in a table. 

 

Introducing Sheet View 

You spoke – we listened. Introducing Sheet View on Excel for the web, a new way of letting you create customized views in an Excel worksheet to sort and filter your data.  You can filter to display only the records that are important to you without being affected by others collaborating in the document. All your cell level edits propagate through the file regardless of your view, so you can make all of your in-cell edits in your Sheet View, too. 

 

Let’s see it in action: 

171609_FY20Q2_M365_APPS_Excel_Sheet_View_GIF_v05.gif

 

If you’re in the document with others, you’ll receive a prompt to enter a Sheet View if you want to sort and filter in a separate view. You can also create a new Sheet View by going to the View tab and clicking the eye icon labelled ‘New’.  

 

clipboard_image_0.png

 

Sheet Views are temporary initially, so once you’re done with your work, you can choose to save the view to reuse later or discard it. To discard, simply exit the Sheet View.  Views can be accessed again in the document at a later time once saved. All you need to do is click on the View tab and find the Sheet View you saved in the drop down list on the left side of the ribbon. 

 

Availability Notes 

We’ve started the rollout to users on Excel for the web and will be available to all Excel for the web users within the coming weeks. 

 

Learn More 

Sheet View in Excel for the web

Learn more about Sheet View 

 

To stay connected to Excel and its community, read the Excel blog posts and send us ideas and suggestions via UserVoice. You can also follow Excel on Facebook and Twitter.  Let us know your thoughts on Sheet View! 

17 Comments
Frequent Visitor

Great Feature! will this feature be available on the desktop version?

Frequent Contributor

this is amazing!

Occasional Contributor

Being Excel on the web version only, makes this fairly useless in our org, with all its other limited capabilities, everyone here is using the desktop version. A certain amount of irony to the fact that Excel on the web can't perform several basic Excel desktop functions, but they jumped over those and went right to adding this. 

Regular Contributor

@Avani_Reddy, great feature!

Regular Visitor

Hi Avni,

I see that this functionality is available only for me in my organization and not others

Do you know why

Occasional Visitor

When should we expect this to show up in our organization?  I'm not familiar with the typical length of a rollout on the web.

Occasional Visitor

i found the same question ,this just work on my web client, not for the other members, why?

Occasional Visitor

@Avani_Reddy  When I tested this feature in an excel file (shared, in web), this feature is appearing for me but not for my colleagues. Is there any specific settings to be activated ? or this feature is yet to be rolled out for all users?

Occasional Visitor

I work for a County Government that use Office 365 with Excel Online, but I do not yet see the sheet view included in our Excel online.  Is there a certain update or release that would include this for us?

Occasional Visitor

I have a 365 ProPlus account.  I am using Excel for web via portal.office.com.  This feature is not available to me.

Occasional Visitor

Hello, the ShareView Option is not available. How do i add it?

clipboard_image_0.png

Occasional Visitor

We're having the same issue.  It works on mine, but not others in my org.  I didn't do anything to turn this feature on, it was just available one day.  How does someone activate this feature if it isn't showing for them?

@Bryan360 , you can do nothing with that, only wait while Microsoft activate the feature for the account

Occasional Visitor

@Sergei Baklan thanks for the note.  We're all on the same corp 360 account.  It's odd that they'd only activate this for some users in an account, but not all at once.

New Contributor

I work in teams and that is a great new feature.  Thanks for the heads up.

Occasional Visitor

I'm not seeing this feature in Excel On the Web yet. Does this feature need to be reviewed/approved by an admin before it will start showing up?

@ontgov5682 Nope, that's only Microsoft switch it on gradually. Please wait till it'll be deployed.