{"id":277823,"date":"2021-06-17T17:24:07","date_gmt":"2021-06-17T14:24:07","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-a-temporary-view-when-collaborating-in-excel\/"},"modified":"2021-06-17T17:24:07","modified_gmt":"2021-06-17T14:24:07","slug":"how-to-create-a-temporary-view-when-collaborating-in-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-temporary-view-when-collaborating-in-excel\/","title":{"rendered":"#How to Create a Temporary View When Collaborating in Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a288b1825a34\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a288b1825a34\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-temporary-view-when-collaborating-in-excel\/#Feature_Availability_and_Basics\" >Feature Availability and Basics<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-temporary-view-when-collaborating-in-excel\/#How_to_Create_a_Temporary_Sheet_View\" >How to Create a Temporary Sheet View<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-temporary-view-when-collaborating-in-excel\/#Save_Your_Temporary_View\" >Save Your Temporary View<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-temporary-view-when-collaborating-in-excel\/#Switch_or_Leave_a_Sheet_View\" >Switch or Leave a Sheet View<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-temporary-view-when-collaborating-in-excel\/#Other_Views_in_the_Sheet\" >Other Views in the Sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-temporary-view-when-collaborating-in-excel\/#Manage_Sheet_Views\" >Manage Sheet Views<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Create a Temporary View When Collaborating in Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-725718\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Have you ever analyzed data in a shared spreadsheet while another person is sorting or filtering at the same time? With a customized, temporary view in Microsoft Excel, you can stop the madness during collaboration.<\/p>\n<p>While real-time collaboration in Microsoft Office is convenient and often necessary, it can also be disruptive. It\u2019s distracting when the sheet suddenly changes as you\u2019re focusing on data. But by creating a temporary view, you can keep your eyes on what you need to focus on while others continue their own work. And best of all, you can save that view and reuse it.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Feature_Availability_and_Basics\"><\/span>Feature Availability and Basics<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Microsoft calls this Excel feature Sheet Views. Here\u2019s a rundown of its availability and how it works:<\/p>\n<ul>\n<li>The feature is available in Microsoft Excel 365 for Windows and Mac, along with Excel for the web.<\/li>\n<li>In the Excel desktop <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>lication, you must store the file in OneDrive, OneDrive for Business, or SharePoint. The feature will be grayed out otherwise.<\/li>\n<li>Edits that you make at a cell level will be saved no matter which view you\u2019re using.<\/li>\n<li>Sheet View is only available for the active spreadsheet.<\/li>\n<\/ul>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Create_a_Temporary_Sheet_View\"><\/span>How to Create a Temporary Sheet View<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now that you know the basics of Sheet Views in Microsoft Excel, it\u2019s time to put this feature to work. Open your Excel workbook and select a sheet to create the view.<\/p>\n<p>Head to the View tab in the ribbon bar. You\u2019ll see a Sheet View section on the far left of the row. Click \u201cNew.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-728285\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/ViewNewSheetViews-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Go to View and click New in Sheet View\" width=\"650\" height=\"143\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>tely notice a difference in the appearance of your sheet:<\/p>\n<ul>\n<li>The column and row headers will have changed to a black background.<\/li>\n<li>Temporary View will be displayed in the Sheet View dropdown in the ribbon.<\/li>\n<li>An eye icon will have appeared next to the sheet tab name. Hover your cursor over the icon to see the current Sheet View name.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-728287\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/TemporarySheetView-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Temporary Sheet View in Excel\" width=\"548\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you\u2019re in this new temporary view, you can work on your sheet without disruptions from others who are doing the same thing.\u00a0This will allow you to filter and sort as you would if you were working alone.<\/p>\n<p>If another person is actively working on the sheet with filters and sorting, you\u2019ll be asked whether you want to see their work or just your own.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-728288\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/OtherChangesSheetView-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Others making changes message\" width=\"453\" height=\"176\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Save_Your_Temporary_View\"><\/span>Save Your Temporary View<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>One nice feature of a Sheet View is that you can save it, and you can save more than one per sheet. You can do this by clicking \u201cKeep\u201d in the Sheet View section of the ribbon. This saves the view with a default name such as View1, View2, and so on.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-728290\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/KeepSheetView-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Keep to save the Sheet View\" width=\"308\" height=\"119\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also save the view by clicking inside the Sheet View drop-down box in the ribbon and giving it a name of your own.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-728291\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/RenameSheetView-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Rename a Sheet View\" width=\"314\" height=\"112\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Switch_or_Leave_a_Sheet_View\"><\/span>Switch or Leave a Sheet View<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Use the Sheet View drop-down box to change to a different view at any time. To return to the Default view, choose that option from the drop-down list. To simply leave a view, click \u201cExit.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-728293 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/ExitSheetView-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Exit to leave a Sheet View\" width=\"314\" height=\"112\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Other_Views_in_the_Sheet\"><\/span>Other Views in the Sheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The views that you use and save aren\u2019t private. Anyone you\u2019re sharing the sheet with can see and use those views. And they can create views of their own. Each appears in the Sheet View drop-down box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-728292\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/SwitchSheetView-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the drop-down to switch the Sheet View\" width=\"310\" height=\"179\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This is both good and bad. It\u2019s good because you can each take advantage of views that others have saved. But it\u2019s bad because anyone can change a view, whether purposefully or not. Just keep this in mind.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Manage_Sheet_Views\"><\/span>Manage Sheet Views<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to rename, duplicate, or delete a Sheet View, click \u201cOptions\u201d in the Sheet View section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-728296\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/OptionsSheetView-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Options\" width=\"314\" height=\"112\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can manage views saved by all users in one spot.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-728295 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/ManageSheetViews-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Manage Sheet Views\" width=\"535\" height=\"360\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you\u2019re in the middle of analyzing data, using filters, and sorting options, a temporary sheet view in Excel can save you from rework while others use the workbook simultaneously. If you\u2019re interested in views that can save your workbook settings instead, check out how to use custom views in Excel.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use Custom Views in Excel to Save Your Workbook Settings<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/728279\/how-to-create-a-temporary-view-when-collaborating-in-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Create a Temporary View When Collaborating in Excel&#8221; Have you ever analyzed data in a shared spreadsheet while another person is sorting or filtering at the same time? With a customized, temporary view in Microsoft Excel, you can stop the madness during collaboration. While real-time collaboration in Microsoft Office is convenient and often&#8230;<\/p>\n","protected":false},"author":1,"featured_media":277824,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-277823","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/277823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=277823"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/277823\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/277824"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=277823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=277823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=277823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}