Monday, March 21, 2011

How to Restore One Deleted Excel Worksheet


1. Click the 'Office Button' and select 'Save As' from the drop-down menu. Select Excel Workbook from the 'Save As' menu and type a new name for your workbook in the 'File Name' field. Press 'Save.' You will now have two workbooks---your original workbook before you made any changes with the 'deleted' worksheet intact, and the newly saved workbook with all of your changes. Only your newly created workbook will remain open.
2. Open your original workbook. You should now have both workbooks open.
3. Right click on the name tab of the 'deleted' worksheet in your original workbook and click 'Move or Copy...' when the menu appears. Under the 'To book' option, select your new workbook and choose where you would like the worksheet to appear in the 'Before sheet' option. Click 'OK.' Note that Excel takes you to your new workbook and the 'deleted' worksheet is displayed.
4. Check to make sure that links between worksheets, formulas and macros are functioning as expected. The next step will eliminate your original workbook, so be absolutely certain that your new workbook is correct before moving forward. If everything is in order, go back to your original workbook and close it.
5. Save your new workbook, renaming it with the original workbook name. The workbook with the 'deleted' worksheet will be overwritten with your now correct workbook.

Blogger news