Excel Tabs dissapeared

%3CLINGO-SUB%20id%3D%22lingo-sub-2236425%22%20slang%3D%22en-US%22%3EExcel%20Tabs%20dissapeared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2236425%22%20slang%3D%22en-US%22%3E%3CP%3EI%20moved%20an%20excel%20tab%20that%20I%20was%20working%20on%20to%20my%20mac%20desktop%20in%20order%20to%20create%20a%20new%20excel%20file.%20But%20the%20tab%20completely%20disappeared.%20How%20to%20I%20restore%20or%20get%20the%20tab%20back%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2236425%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2237709%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Tabs%20dissapeared%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2237709%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1009040%22%20target%3D%22_blank%22%3E%40sabrinaas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22co8aDb%20XcVN5d%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.techonthenet.com%2Fexcel%2Fsheets%2Funhide2011.php%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%3CSTRONG%3EUnhide%20All%20or%20Selected%20Sheets%20Using%20Custom%20View%3C%2FSTRONG%3E%3C%2FA%3E%3C%2FDIV%3E%3CDIV%20class%3D%22RqBzHd%22%3E%3COL%20class%3D%22X5LH0c%22%3E%3CLI%3E%3CSTRONG%3EUnhide%20all%3C%2FSTRONG%3E%20the%20%3CSTRONG%3Eworksheets%3C%2FSTRONG%3E%20to%20begin%20with.%3C%2FLI%3E%3CLI%3EClick%20the%20View%20%3CSTRONG%3Etab%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EClick%20on%20Custom%20Views.%3C%2FLI%3E%3CLI%3EIn%20the%20Custom%20Views%20dialog%20box%2C%20click%20on%20Add.%20This%20will%20open%20the%20Add%20view%20dialog%20box.%3C%2FLI%3E%3CLI%3EEnter%20any%20name%20for%20this%20view%20where%20%3CSTRONG%3Eall%3C%2FSTRONG%3E%20the%20%3CSTRONG%3Esheets%3C%2FSTRONG%3E%20(or%20selected%20%3CSTRONG%3Esheets%3C%2FSTRONG%3E)%20are%20visible.%3C%2FLI%3E%3CLI%3EClick%20OK.%3C%2FLI%3E%3C%2FOL%3E%3CP%3EAdditional%20info%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhere-are-my-worksheet-tabs-42623d50-2f9b-4583-ad9c-f1b381185e48%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EWhere%20are%20my%20worksheet%20tabs%3F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

I moved an excel tab that I was working on to my mac desktop in order to create a new excel file. But the tab completely disappeared. How to I restore or get the tab back? 

3 Replies

@sabrinaas 

  1. Unhide all the worksheets to begin with.
  2. Click the View tab.
  3. Click on Custom Views.
  4. In the Custom Views dialog box, click on Add. This will open the Add view dialog box.
  5. Enter any name for this view where all the sheets (or selected sheets) are visible.
  6. Click OK.

Additional info: Where are my worksheet tabs?

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

@NikolinoDE Thank you for answering. I found out what was happening. On my other computer, it would create a new excel file when I dragged the tab off onto the desktop. However, on this one, the data went to an adobe pdf of the file. So that's why I couldn't see it when looking through excel and on the desktop etc, it was showing as a pdf. 

I am happy that you were able to correct the error yourself.

Wish you continued fun with Excel.

Thanks for the feedback and have a nice day :))

Nikolino