To close Version History in Excel for Microsoft 365 on Windows, open the Version History pane and select its X in the pane’s upper corner. This closes the list; it does not delete saved versions or turn off version history. Before starting, make sure you have the workbook open and know whether it is saved to OneDrive or SharePoint, since cloud storage is what usually provides version history.
What You’ll Need
- The workbook open in Excel for Microsoft 365 on Windows, Mac, or Excel for the web.
- For a Version History list to appear, the workbook generally needs to be stored in OneDrive or SharePoint and you need permission to access it. A workbook saved only on your computer may not have this cloud version history.
- No special permission or setting is needed just to close the pane. Closing it is a display action, not a change to the file’s history.
Step-by-Step
- Open the correct workbook. In Excel, check the workbook name in the title bar before changing anything. If you have multiple workbooks open, select the one whose version list you want to dismiss. Closing the pane does not close the workbook or affect other workbooks.
- Open Version History if it is not already visible. In Excel for Microsoft 365 on Windows, select File > Info > Version History. Excel opens a list of available saved versions, usually in a pane on the right. If the pane is already open, skip this step. You do not need to choose or restore a version simply to close the list.
- Find the pane’s close control. Look at the top-right area of the Version History pane, not the top-right corner of the whole Excel window. Select the X on the pane. The version list should disappear while the workbook remains open.
- Check that you closed only the pane. Confirm that the workbook grid and its title bar are still visible. If the entire Excel window disappears, you may have selected the application window’s close control instead. Reopen the workbook from Excel’s recent files or its OneDrive or SharePoint location, then use the pane-specific X.
- Continue working as usual. Closing Version History does not undo edits, restore an earlier version, or stop cloud saving. If AutoSave is on, edits can continue to save to the cloud. If you made changes you need to keep, check the AutoSave indicator or use Ctrl+S on Windows to save the workbook.
- Use the equivalent route on another platform. In Excel for Mac, open the list using File > Browse Version History where that command is available, then close its history window or pane using the displayed close control. In Excel for the web, open the workbook’s Version History from the File menu or the workbook name menu, depending on the current interface, and use the X on the history pane. The layout can differ from Windows desktop Excel, but closing the pane still only hides the list.
If you meant that you want to stop Excel from keeping cloud versions, closing the pane will not do that. Excel does not provide a general workbook button that deletes or disables OneDrive or SharePoint version history. That history is managed by the storage service and may also be subject to an organization’s retention settings.
Common Mistakes
- Assuming close means delete. The pane’s X dismisses the interface; it does not remove any listed version. This is the safe choice when you only want more room to view the sheet.
- Restoring a version when you only want to dismiss the list. Selecting a previous version can open it for review, and choosing a restore option changes the current file to an earlier state. Read the confirmation carefully. Restoring is not necessary for closing the pane.
- Looking for the pane’s X in the wrong place. Excel has an application-window close button as well as controls for side panes. Use the X attached to the Version History pane, not the one that closes the whole Excel window.
- Expecting local files to have cloud history. A file saved only to a local drive may not show the same version list as a workbook stored in OneDrive or SharePoint. Windows File History, backups, or AutoRecover are separate mechanisms and are not the Version History pane.
- Thinking the X switches off AutoSave. The history pane and AutoSave are separate. Closing the list does not change the AutoSave switch, your sharing settings, or how the cloud service records changes.
Tips
- Identify the storage location first. If the workbook is shared or its title bar shows a OneDrive or SharePoint location, its versions are generally associated with that cloud file. This helps explain why a coworker may see the same version history even after you close your own pane.
- Use the version list for review, not as a disposable pop-up. If you opened it to check who changed a workbook or when a change occurred, note the relevant details before closing. Available details and version labels can vary with the service and your access.
- Save a separate copy before major recovery work. If your actual goal is to recover older content, consider making a copy of the current workbook first. Then inspect the older version and decide whether to restore it. This reduces the chance of losing newer edits while comparing states.
- Remember that version history is not the same as Undo. Ctrl+Z reverses recent actions in the active editing session. Version History lets you access saved states of an eligible cloud file. Closing the pane has no effect on either feature.
- Allow for a different interface. Microsoft updates Excel, and the exact menu placement can vary between desktop and web editions. Look for the command named Version History or Browse Version History, then close the resulting pane or window with its own close control.
Troubleshooting
The X is missing or hard to see. Make sure the Version History pane is open and look at its top edge, rather than the Excel ribbon or the application frame. If the Excel window is narrow, maximize it or widen it so the pane controls are easier to distinguish. On a Mac or in a browser, the history view may appear as a separate panel or window; use the close control belonging to that view.
Version History does not appear in the menu. First check whether the workbook is saved to OneDrive or SharePoint. A file on a local disk, network location, or unsupported storage location may not offer cloud version history. If it is a cloud file, confirm that you are signed in to the account that has access and that you opened the cloud-stored copy rather than a downloaded duplicate. In a managed work or school account, an administrator’s policies or permissions can affect access.
The pane closes, but the list returns. You may have reopened it by selecting Version History again, or a second workbook may have its own history pane open. Close the pane in the workbook where it appears. If it keeps opening unexpectedly, check whether you are switching between browser tabs or Excel windows and identify which one is active.
You cannot see the workbook behind the pane. This usually means the pane is taking up space, not that the sheet is gone. Select the pane’s X. If the workbook itself is hidden or minimized, restore the Excel window from the taskbar or Dock. Avoid using the application close button unless you intend to close the workbook window.
You wanted to remove older versions, not just close the pane. Do not use the X expecting it to erase history. Version deletion and retention are controlled by OneDrive, SharePoint, and sometimes organization policies; available controls depend on the account, file, and permissions. Check the storage service’s file-management options or ask your Microsoft 365 administrator before changing retention or deleting versions. For a personal backup, make a separate copy of the workbook rather than relying on deletion as a way to conceal or undo a change.
A restored version seems to have replaced newer work. Check the workbook’s Version History again, if available, and inspect the listed states before making another change. Restoring an older state does not mean the prior state is necessarily erased; the service may record the restore as another version. If the file is shared, coordinate with collaborators so they do not overwrite recovered work while you are checking it.
Frequently Asked Questions
Does closing Version History delete the versions?
No. It only closes or hides the pane. The saved versions remain subject to the cloud service’s retention and deletion rules.
Can I turn off Version History for one Excel workbook?
There is no general Excel switch that turns off OneDrive or SharePoint version history for an individual workbook. The storage service or an organization administrator may control versioning and retention.
Will closing the pane discard my unsaved edits?
No. Closing the history pane does not discard edits. Saving is a separate action; check AutoSave or press Ctrl+S on Windows if you want to save manually.
Why is Version History unavailable for my file?
The workbook may be saved locally, you may be signed into the wrong account, or you may lack access. Version history is generally associated with files stored in OneDrive or SharePoint, and availability can depend on account settings.
How do I close Version History in Excel for Mac?
Open it from File > Browse Version History when available, then use the close control shown for the history view. The Mac layout differs from Windows, so the control may appear on a separate window rather than in the same place.
Can I close Version History with a keyboard shortcut?
There is no single reliable Excel shortcut specifically for closing the Version History pane across Windows, Mac, and the web. Use the pane’s visible X; pressing Esc may close some transient views, but it is not a consistent substitute.
Related
- Excel Subscript: How to Change Text to Subscript
- How to Change Strikethrough Color in Excel Cells Easily
- How to Change Note Color in Excel for Easier Scanning
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add the Same Header in Excel on Every SheetTo add the same print header to every worksheet in an Excel workbook, select and group the sheets,…
- Excel Data Validation: Create a Filtered Dropdown ListYes. In Excel for Microsoft 365, create a helper formula that returns the matching items with FILTER, then…
- Excel Consolidate Ranges: Methods, Steps, and LimitsTo consolidate ranges in Excel, use Data > Consolidate to combine values with a function such as Sum,…
- Excel Shortcut Keys for Data Entry: A Practical GuideFor data entry in Excel for Microsoft 365 on Windows, use Tab to move right, Enter to move…
- How to Edit Date Format in Google Sheets: Complete GuideTo edit a date’s appearance in Google Sheets, select the date cells, then choose Format > Number and…
- Excel Add Values to a Dropdown List: Easy MethodsTo add a value to an Excel dropdown, edit the list named in its Data Validation settings or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.