'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Recover Deleted Excel Columns Using Version History
Question details
The user needs to recover spreadsheet columns that unexpectedly show as deleted in the Changes pane after hiding them or syncing the file.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Hiding columns in Excel for the web, saving, or synchronizing the workbook with the desktop app.
- Observed behavior
- Columns that were hidden in the web version appear as deleted data in the desktop application's Changes pane due to synchronization alterations.
Verify that your Excel workbook was saved to a cloud service like OneDrive or SharePoint, as retrieving an earlier version requires cloud-based file history tracking.
Restore an Earlier Version Using OneDrive or SharePoint
Use the built-in Version History feature in your cloud storage to revert the workbook to a state before the columns were marked as deleted.
When Excel files are synchronized between the web platform and the desktop app, sync conflicts can sometimes misinterpret hidden columns as deleted data. The most effective way to retrieve this data is to load a previous version from the cloud.
Always ensure you save a standalone copy of your current flawed workbook locally. This allows you to compare the recovered workbook with the current version and prevents accidental loss of any new edits made after the columns disappeared.
Open your current Excel file, click 'File' > 'Save As', and save a copy of the workbook to your local desktop as a precaution.
Navigate to your OneDrive or SharePoint online folder, locate the affected Excel file, right-click on it, and select 'Version History' from the context menu.
Browse the panel of saved versions organized by date and time. Look for a version timestamped right before you hid the columns or noticed the data loss.
Click 'Restore' on the selected older version. Open the newly restored file in your Excel desktop app to confirm the columns are visible and intact.
Try WPS Office for a More Reliable Spreadsheet Experience
Struggling with web-to-desktop synchronization errors in your spreadsheets? WPS Office offers a highly stable, lightweight, and free alternative. Enjoy full offline editing, reliable cloud backup through WPS Cloud, and seamless handling of your existing files.
- 1. Download the software: Install WPS Office for free from the official website onto your PC or Mac.
- 2. Open your files directly: Double-click your existing Microsoft Excel (.xlsx) files to instantly open and edit them in WPS Spreadsheet without any formatting loss.
- 3. Enable Cloud Backup: Sign in to activate WPS Cloud, ensuring your work is auto-saved and previous document versions are always accessible.
Frequently Asked Questions
Why do my hidden columns in Excel for the web appear deleted on desktop?
This discrepancy is typically caused by a synchronization conflict or a brief loss of connectivity when saving. The cloud version may misinterpret the 'hidden' attribute as a deletion when syncing changes to the desktop client's Changes pane.
Can I recover lost Excel columns if I do not use OneDrive?
If you do not use OneDrive or SharePoint, you cannot use the cloud Version History feature. You can only recover the columns if you manually saved a backup copy, or if Excel's local AutoRecover feature saved a snapshot before the columns were lost.
How do I correctly unhide columns in an Excel spreadsheet?
Click and drag to highlight the column letters on both sides of the hidden columns. Right-click the selected column headers and choose 'Unhide' from the drop-down menu.
