[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Microsoft 365 has unlocked powerful features for collaboration, making it even easier to share an Excel file<\/a> or work on a spreadsheet simultaneously using the Excel Co-Authoring<\/a> functionality. The downside to having multiple users editing a file at the same time is that it may interfere with your viewing of the data. For example, you might try to analyze a column that suddenly disappears because someone else has filtered or sorted it.<\/p>\n Now you can create customized views, aka Sheet Views, in Excel so that others can\u2019t interfere with your work. In this article, you\u2019ll learn what Sheet View is and how to create a temporary Sheet View in Excel, remove it, and switch between your custom Sheet Views.<\/p>\n [\/et_pb_text][et_pb_text module_id=”what-is-sheet-view-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Sheet Views are an Excel feature that allows you to create different views of the same data in a spreadsheet. It\u2019s extremely useful for collaboration since it allows multiple users to view the same data in different ways at the same time.<\/p>\n If you find that the Excel Sheet View is missing or not working, you might not have the required version of Microsoft 365. If you do, you need to make sure it is saved to OneDrive or SharePoint. Let\u2019s explore how you can enable Sheet View in Excel.<\/p>\n If you find the Sheet View options disabled, then this is how you can check that your Excel is online.<\/p>\n Open your Excel workbook and click on the file name at the top. A \u201cFile Name\u201d drop-down box will appear where you can select the online folder.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-sheet-view-file-name-onedrive-location.webp” alt=”Excel sheet view \u2014 File name drop-down under the workbook title showing the OneDrive Documents location” title_text=”File name drop-down under the workbook title showing the OneDrive Documents location” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now, you\u2019ll see how easy it is to create a Temporary Sheet View in Excel.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-create-a-temporary-sheet-view-in” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Sheet Views are temporary because you can easily remove them at any time. This is how you can create a Temporary Sheet View in your Excel.<\/p>\n 1.<\/strong> Open an Excel workbook and click on any sheet to make sure it\u2019s active.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-sheet-view-active-sheet.webp” alt=”Excel sheet view \u2014 contact list workbook open on the Home tab with Sheet1 active” title_text=”Contact list workbook open on the Home tab with Sheet1 active” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Head to the \u201cView\u201d tab and click on \u201cNew\u201d within the \u201cSheet View\u201d group.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-sheet-view-view-tab-new-button.webp” alt=”Excel sheet view \u2014 View tab with the Sheet View group showing Default and the New button” title_text=”View tab with the Sheet View group showing Default and the New button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Notice how your column and row headers are now black, and Excel displays \u201cTemporary View\u201d as a drop-down option in the Sheet View group. Next to your sheet tab name at the bottom, an eye icon should also appear.<\/p>\n 3.<\/strong> To remove the \u201cTemporary View\u201d, click \u201cExit\u201d within the \u201cSheet View\u201d group.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-sheet-view-temporary-view-exit.webp” alt=”Excel temporary view \u2014 Temporary View in the Sheet View drop-down with Exit, and an eye icon on the Sheet1 tab” title_text=”Temporary View in the Sheet View drop-down with Exit, and an eye icon on the Sheet1 tab” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can now easily work on your data without being interrupted. In case another user applies a filter or tries to sort data, Excel will ask you whether you want to work on their view or continue to work on your own. Let\u2019s explore how you can use Sheet View in Excel to have full control over how you can view your data.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-use-sheet-view-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Excel first allows you to create a Temporary View, which you can easily exit, as shown before. However, if you would like to save the Temporary View, this is what you need to do.<\/p>\n The great thing about Sheet View is that you can save more than one view per sheet.<\/p>\n 1.<\/strong> In the \u201cSheet View\u201d group, click on \u201cKeep\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-sheet-view-keep-temporary-view.webp” alt=”Excel sheet view \u2014 Keep button next to Temporary View in the Sheet View group” title_text=”Keep button next to Temporary View in the Sheet View group” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> You should now see the default name of your view has replaced \u201cTemporary View\u201d in the drop-down menu.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-sheet-view-saved-view1.webp” alt=”Excel sheet view \u2014 saved view named View1 in the Sheet View drop-down” title_text=”Saved view named View1 in the Sheet View drop-down” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n However, you can customize the Sheet View name so that it\u2019s easier for you to switch between views. Let\u2019s see how you can rename your custom view.<\/p>\n Renaming your custom views can be done in two simple steps.<\/p>\n 1.<\/strong> Click on \u201cOptions\u201d next to the \u201cNew\u201d button. Then, select the Sheet View to rename, and select \u201cRename\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-sheet-view-options-rename.webp” alt=”Excel sheet view options \u2014 dialog with View1 selected and Rename, Duplicate and Delete buttons” title_text=”Dialog with View1 selected and Rename, Duplicate and Delete buttons” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Type in the new name and click \u201cSave\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-sheet-view-rename-dialog.webp” alt=”Excel sheet view \u2014 Rename Sheet View dialog with View1 in the name box and a Save button” title_text=”Rename Sheet View dialog with View1 in the name box and a Save button” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n But what if you\u2019ve saved different custom views and want to switch between them? Here\u2019s how to do it.<\/p>\n You can switch between your saved custom views from the \u201cSheet View\u201d drop-down box.<\/p>\n 1.<\/strong> To switch to a different Sheet View, click on the drop-down list and select the desired Sheet View. Here, I would like to switch to “Sorted A-Z”, a view I saved earlier, which filters the last column and sorts the first column as A-Z.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-sheet-view-switch-sorted-a-z.webp” alt=”Excel sheet view \u2014 Sorted A-Z view selected in the drop-down with the list sorted and filtered” title_text=”Sorted A-Z view selected in the drop-down with the list sorted and filtered” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> To leave a Sheet View, click \u201cExit\u201d. You can see how the drop-down box now shows \u201cDefault\u201d as the current view.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-sheet-view-exit-to-default.webp” alt=”Excel sheet view \u2014 Sheet View drop-down back on Default after exiting the view” title_text=”Sheet View drop-down back on Default after exiting the view” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you\u2019re wondering whether you can access other views in the shared Excel, you\u2019ll be happy to learn that it\u2019s possible. However, this also means that there is no private view option. As a result, any other user can also see and accidentally change your custom view.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Although Excel Sheet Views might seem like a basic feature, this feature makes collaborative work easier than ever before. You can perform any task on your spreadsheet – basic or complex – and it won\u2019t affect or interfere with your colleagues\u2019 work.<\/p>\n In this article, you have seen how Sheet View makes collaboration in Excel even easier. You should now know how to use the Sheet View functionality in Excel in full. You should also know how to create a Temporary View, how to remove it, and how to manage Sheet Views to go back to a specific Sheet View at any time.<\/p>\n A sheet view only changes what you see. Other people can still edit the data, so to stop changes to the file itself, you can lock and protect the Excel workbook from editing<\/a>. If a change slips through, you can restore a previous version of the Excel file<\/a>. If Excel says a shared file is locked for editing, here’s how to unlock an Excel file locked for editing by me<\/a>. If teammates need their own copy of the data to sort and filter, Sheetgo<\/a>, an AI-powered data automation platform, can transfer filtered Excel data to another workbook<\/a> and keep that copy up to date.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Os dados podem mudar de repente quando v\u00e1rias pessoas trabalham em um arquivo do Excel compartilhado. Veja como usar o modo de exibi\u00e7\u00e3o de planilha do Excel para criar um modo de exibi\u00e7\u00e3o tempor\u00e1rio que n\u00e3o muda.<\/p>","protected":false},"author":2,"featured_media":262992,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[51],"tags":[],"class_list":["post-262981","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=262981"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262981\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/262992"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=262981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=262981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=262981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}What is sheet view in Excel?<\/h2>\n
How do I enable sheet view in Excel?<\/h3>\n
How to create a temporary sheet view in Excel?<\/h2>\n
How to use sheet view in Excel?<\/h2>\n
How to save a sheet view in Excel?<\/h3>\n
How to rename a sheet view in Excel?<\/h3>\n
How to switch or leave a sheet view?<\/h3>\n
Conclusion<\/h2>\n