Feature Updates for Sheet View

Published Nov 17 2021 10:00 AM 2,397 Views
Microsoft

Have you ever collaborated with someone else in a workbook and suddenly the data table you’re looking at changes drastically? Often, this happens because someone has filtered or sorted the table while you were looking at the data. We realize that while people want to work together in a file, it doesn’t necessarily mean everyone has the same task. To provide users with the freedom to collaborate as they want, we developed Sheet View. With Sheet View, you can create customized views in an Excel workbook to freely sort and filter without being impacted by others. You all told us how much you loved this feature during collaboration, but told us that we can do even better. Here are some recent improvements we've made to Sheet View.

 

Introducing Sheet View's hide rows and columns

We heard your feedback - that supporting sorts and filters alone in a Sheet View does not accomplish all of your workflows. One of our top asks for Excel for the Web was to support hiding rows and columns in a Sheet View, as well as expanding and collapsing grouped rows and columns. We are excited to announce that these actions are now supported while working in a Sheet View across all platforms.

 

Let's see it in action:

 

Introducing Sheet View mobile

Modern ways of working require modern solution. With people working from anywhere and on different devices, we’re seeing more people using mobile to get work done. We're excited to announce that Sheet View is now supported on iOS, iPad, and Android.

 

Sheet View Mobile iOS.jpg

 

Feedback

Your feedback is important to us! Please continue to send feedback to Microsoft in the Excel app about Sheet View as you use our new features and let us know what you want to see next.

 

Availability

Hiding rows and columns in Sheet View is supported on Excel desktop builds greater than or equal to 16.0.14005.10000, July semi-annual build, and June MEC build. Sheet View iOS mobile is available in 100% production beginning in October, and 100% production for Android beginning in September.

 

Learn More 

Sheet View in Excel for the web

Learn more about Sheet View 

1 Comment
%3CLINGO-SUB%20id%3D%22lingo-sub-2972562%22%20slang%3D%22en-US%22%3EFeature%20Updates%20for%20Sheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2972562%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20ever%20collaborated%20with%20someone%20else%20in%20a%20workbook%20and%20suddenly%20the%20data%20table%20you%E2%80%99re%20looking%20at%20changes%20drastically%3F%20Often%2C%20this%20happens%20because%20someone%20has%20filtered%20or%20sorted%20the%20table%20while%20you%20were%20looking%20at%20the%20data.%20We%20realize%20that%20while%20people%20want%20to%20work%20together%20in%20a%20file%2C%20it%20doesn%E2%80%99t%20necessarily%20mean%20everyone%20has%20the%20same%20task.%20To%20provide%20users%20with%20the%20freedom%20to%20collaborate%20as%20they%20want%2C%20we%20developed%20Sheet%20View.%20With%20Sheet%20View%2C%20you%20can%20create%20customized%20views%20in%20an%20Excel%20workbook%20to%20freely%20sort%20and%20filter%20without%20being%20impacted%20by%20others.%20You%20all%20told%20us%20how%20much%20you%20loved%20this%20feature%20during%20collaboration%2C%20but%20told%20us%26nbsp%3Bthat%20we%20can%20do%20even%20better.%20Here%20are%20some%20recent%20improvements%20we've%20made%20to%20Sheet%20View.%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EIntroducing%20Sheet%20View's%20hide%20rows%20and%20columns%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EWe%20heard%20your%20feedback%20-%20that%20supporting%20sorts%20and%20filters%20alone%20in%20a%20Sheet%20View%20does%20not%20accomplish%20all%20of%20your%20workflows.%20One%20of%20our%20top%20asks%20for%20Excel%20for%20the%20Web%20was%20to%20support%20hiding%20rows%20and%20columns%20in%20a%20Sheet%20View%2C%20as%20well%20as%20expanding%20and%20collapsing%20grouped%20rows%20and%20columns.%20We%20are%20excited%20to%20announce%20that%20these%20actions%20are%20now%20supported%20while%20working%20in%20a%20Sheet%20View%20across%20all%20platforms.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20see%20it%20in%20action%3A%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2010.5pt%3B%20color%3A%20%232f2f2f%3B%22%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252Fdbm1oC2G5Ms%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253Ddbm1oC2G5Ms%26amp%3Bkey%3Db0d40caa4f094c68be7c29880b16f56e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22200%22%20height%3D%22112%22%20scrolling%3D%22no%22%20title%3D%22YouTube%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EIntroducing%20Sheet%20View%20mobile%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EModern%20ways%20of%20working%20require%20modern%20solution.%20With%20people%20working%20from%20anywhere%20and%20on%20different%20devices%2C%20we%E2%80%99re%20seeing%20more%20people%20using%20mobile%20to%20get%20work%20done.%20We're%20excited%20to%20announce%20that%20Sheet%20View%20is%20now%20supported%20on%20iOS%2C%20iPad%2C%20and%20Android.%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%20image-alt%3D%22Sheet%20View%20Mobile%20iOS.jpg%22%20style%3D%22width%3A%20497px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F327462iE84A06CCFBDD6942%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Sheet%20View%20Mobile%20iOS.jpg%22%20alt%3D%22Sheet%20View%20Mobile%20iOS.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EFeedback%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EYour%20feedback%20is%20important%20to%20us!%20Please%20continue%20to%20send%20feedback%20to%20Microsoft%20in%20the%20Excel%20app%20about%20Sheet%20View%20as%20you%20use%20our%20new%20features%20and%20let%20us%20know%20what%20you%20want%20to%20see%20next.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2010.5pt%3B%20color%3A%20%232f2f2f%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EAvailability%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EHiding%20rows%20and%20columns%20in%20Sheet%20View%20is%20supported%20on%20Excel%20desktop%20builds%20greater%20than%20or%20equal%20to%26nbsp%3B16.0.14005.10000%2C%20July%20semi-annual%20build%2C%20and%20June%20MEC%20build.%20Sheet%20View%20iOS%20mobile%20is%20available%20in%20100%25%20production%20beginning%20in%20October%2C%20and%20100%25%20production%20for%20Android%20beginning%20in%20September.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2010.5pt%3B%20color%3A%20%232f2f2f%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ELearn%20More%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsheet-views-in-excel-0eea3dc5-d7d1-44c5-a953-25ebfbd6c1a6%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESheet%20View%20in%20Excel%26nbsp%3Bfor%20the%20web%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flearn-more-about-sheet-views-87fb6758-edbc-4cd0-bd68-76124775e9f8%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ELearn%20more%20about%20Sheet%20View%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2972562%22%20slang%3D%22en-US%22%3E%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252Fdbm1oC2G5Ms%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253Ddbm1oC2G5Ms%26amp%3Bkey%3Db0d40caa4f094c68be7c29880b16f56e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22200%22%20height%3D%22112%22%20scrolling%3D%22no%22%20title%3D%22YouTube%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3ELearn%20more%20about%20our%20recent%20improvements%20to%20Sheet%20View%2C%20including%20the%20ability%20to%20hide%20rows%20and%20columns%20and%20our%20latest%20support%20for%20Sheet%20View%20on%20mobile.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2972562%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2977575%22%20slang%3D%22en-US%22%3ERe%3A%20Feature%20Updates%20for%20Sheet%20View%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2977575%22%20slang%3D%22en-US%22%3E%3CP%3ESupporting%20of%20hided%20rows%2Fcolumns%20is%20a%20great%20addition%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Nov 17 2021 12:09 PM
Updated by: