How to Unhide a Microsoft Excel Sheet

wagar ahmed 0 Reputation points
2023-04-24T17:38:19.6933333+00:00

I utilized the hide function on excel and the entire program completely disappeared. Upon trying to unhide it, it would not let me. Then it was not found in my files. What can I do?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,599 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Jorge Garza 0 Reputation points
    2023-04-24T21:37:48.1+00:00

    Do you already try with: File tab, Info, Manage Workbook, Recover Unsaved Workbooks? Also look for the last unsaved file. Which version of Excel do you have?

    0 comments No comments

  2. Jorge Garza 0 Reputation points
    2023-04-25T00:42:33.0733333+00:00

    Do you already try with: File tab, Info, Manage Workbook, Recover Unsaved Workbooks? Also look for the last unsaved file. Which version of Excel do you have?

    0 comments No comments

  3. Emi Zhang-MSFT 22,951 Reputation points Microsoft Vendor
    2023-04-25T06:38:08.1466667+00:00

    Hi @wagar ahmed,

    How did you hide the Workbook?

    Can you find the file in Windows?

    If you can find the Workbook in Windows but it is grayed out when opening. I suggest you go to View tab- select Unhide option: User's image

    If my understanding is incorrect, please provide more information about your question or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  4. Tanay Prasad 2,110 Reputation points
    2023-05-05T05:42:09.07+00:00

    Hi,

    If you have used the hide function in Excel and the entire program disappeared, there are a few things you can try to recover it:

    1. Use the "Unhide" function in Excel. If you accidentally hid a worksheet or workbook in Excel, you can use the "Unhide" function to make it visible again. To do this, right-click on any visible worksheet tab and select "Unhide". From there, you can select the worksheet or workbook that you want to unhide.
    2. Recover an unsaved workbook. If you were working on the workbook and hadn't saved it yet, Excel may have created a backup copy that you can recover. In Excel, go to the "File" tab, then select "Info". Look for the "Manage Workbook" section and select "Recover Unsaved Workbooks". From here, you can select the file you want to recover.
    3. As mentioned by Emi Zhang in this thread, you can also try unhiding it from the View Tab (i.e. if the file is still there and not deleted).

    Best Regards.

    0 comments No comments