How can I restore a column that was deleted by mistake after I have saved the
document. Can one go back to a previous saved version stored in excel
somewhere. Although I don't think it is actually possible, I have to at
least ask if it is possible.

Don't worry, there are a few ways to restore a deleted column in Excel even if you have saved the document. Here are some steps you can follow:

1. Undo the deletion: The first thing you can try is to undo the deletion by pressing "Ctrl + Z" on your keyboard or by clicking on the "Undo" button in the Quick Access Toolbar. This will restore the deleted column if you haven't done any other actions after deleting it.
   
2. Restore from the Recycle Bin: If you have deleted the entire worksheet or workbook, you can check your Recycle Bin to see if it's still there. To do this, open the Recycle Bin on your desktop, find the deleted file, right-click on it, and select "Restore". This will restore the file to its original location.
   
3. Use the AutoRecover featu Excel has an AutoRecover feature that automatically saves a backup copy of your workbook at regular intervals. To access this feature, go to "File" "Options" "Save" and check the "Save AutoRecover information every X minutes" box. If Excel crashes or you accidentally close the workbook without saving, you can recover the unsaved changes by opening Excel and looking for the AutoRecover file.
   
4. Check previous versions: If you have enabled the "AutoSave" feature in Excel, you can check the previous versions of your workbook by going to "File" "Info" "Version History". This will show you a list of all the previous versions of your workbook, and you can select the one you want to restore.

I hope these steps help you restore your deleted column in Excel.

You could IF you had set the "Always create backup" option on. Otherwise
you will rely on your weekly document backup store.

Lucia wrote:

How can I restore a column that was deleted by mistake after I have saved the
document. Can one go back to a previous saved version stored in excel
somewhere. Although I don't think it is actually possible, I have to at
least ask if it is possible.

Not possible...
--
HTH...

Jim Thomlinson


"Lucia" wrote:

How can I restore a column that was deleted by mistake after I have saved the
document. Can one go back to a previous saved version stored in excel
somewhere. Although I don't think it is actually possible, I have to at
least ask if it is possible.

This is not an Excel feature, but if you are using a network depending on how
your network is set up you may be able to access previous versions.

On my work network, if I browse to a file and right click on it and select
properties, in addidtion to the usual Geneal, Security and Summary Tabs I get
a Tab called Previous Versions. On this tab I have the option to restore
older versions of the file.

This has saved me some work on a couple of occasions.
--
If this helps, please remember to click yes.


"Lucia" wrote:

How can I restore a column that was deleted by mistake after I have saved the
document. Can one go back to a previous saved version stored in excel
somewhere. Although I don't think it is actually possible, I have to at
least ask if it is possible.