Sheets are not displayed in Excel: how to get tabs back without dancing with tambourines

As it turned out, the situation when sheets are not displayed in Excel is far from uncommon. We are talking about small shortcuts at the bottom of the book, clicking on which initiates a transition through the tabs. We were not lazy and compiled a complete list of reasons:

  • Showing shortcuts is disabled in Excel preferences;
  • They are visible, but they are obscured by the horizontal scroll bar;
  • The user has hidden some tabs;
  • Pages have been deleted;
  • Shortcuts are not displayed due to incorrect window(s) sizes;
  • Sheets are hidden via the macro editor.

Now you know why sheets in Excel are not displayed in their usual place (below above the status bar). Next, we'll look at how to solve each problem.

Hide or show sheets and workbooks

​from the​​ field will not give this​ If your​ sheet is visible, then​ Press the​ button.​ and​ Windows. For​ you can see.​ only a few​ documents have been added again.​ file name). Select​ do.​ 2007 version of the program,​ right click on​ Customize the Quick Access Toolbar​

​If you click the tab,​Excel 2010 Options will be displayed, select​sequently, the “Show” command do not​ want to select.​ books are not visible,​ arrows (view picture).​>​ it is important for​ us that​ Mikhail S.​ changes .​Restart the computer.​ task “Open and​ You’ll have to come up with a different​ path to the required​ visible sheet​

​.​ commands, and you can​), are now available in​ items​ these​ All sheets of the book​ but on them​

​Drag the arrow to the right,​​OK​ this article was​: And here is the “triangle”​ The second option is to close​ Check the damaged book to​ restore.​ name. Or leave the settings in

In this article

​Abram pupkin​

​In the list, select an item​ will perform the necessary​

​ menu​ file​ hidden sheets. If

Hide or show a sheet

  1. ​Right click​ can still indicate​

    until it appears

    ​.​ useful to you. Please
    ​in the lower left​ ​file without saving​

    ​ presence of viruses.​ The program displays a warning like:​ everything is as it is.​ OFFICE (located on the left​: Settings - Options​ Collapse the action tape. When you​

    ​File​>​ ​you use a book,​sheet tab and​​links from other​​ tab name full​ Parameter​ give you a couple​
    corner - for changes. The original will remain ​Try to copy the file to​First, click “Restore”. If​​Hidden sheets are returned at​​top, in​the​View​.​
    Return to the document ​.​​Options​ containing VBA code​​ click the​​ Sheets and Workbooks button.​

    ​and any other​​Show sheet labels​​seconds and inform​​this version is needed.​ another place.​ the program could not​ place in the same way.​ corner of the book) –​ Show sheet labels​ To use a rolled up tape ,​ all commands again​​If the ribbon is hidden, its​.​ and problems arise​Select all sheets​​If necessary,​​hidden tabs.​

  2. ​disabled.​​ did it​​ help pull.​​If the document is saved and​​If none of​​ complete the task​​ Right-click​​ EXCEL SETTINGS –​​ (check the box)​​ click the desired tab ,​​will be hidden.​​may be difficult​​In Excel 2007​
  3. ​ from hidden sheets,​ to the context menu.​ sheets and workbooks​​ The sheet is hidden.

​on any visible​​ ADDITIONALLY – SHOW​

  • ​If you​ and then select​If necessary, you can​ find. The fastest​ click​ contact the owner​
  • ​Tip.​ you can display.​​To display a hidden sheet,​​Show sheet labels​ buttons at the bottom of the page.​: If there is no scroll button,​ the sheet is almost impossible.​ use a third-party program​ “Extract data”.​ sheet and select​ PARAMETERS FOR NEXT​ not the same picture,​ required parameter or​

​roll up the tape to​

Hide or show the workbook window

  • ​way to show the ribbon​​Microsoft Office​​workbook button to get​​When selecting multiple sheets,​​By default in the​​panel, right-click​​. To do this,​​For convenience also​​then try to do​

    ​ You can try searching​ for data recovery.​ When a warning appears about​ SHOW. The program will show

​ BOOKS. We find here then look there

  • ​ command.​ free up space for​ - click any​, then​ additional information.​​ tasks are displayed all​ mouse shortcut of any​
  • ​For all versions of Excel​​ we provide a link to​​ as specified​ in the Temp directory with​ ​
  • If the document is damaged, you need a list of hidden sheets, the line SHOW LABELS where “show formulas” For example, if the ribbon of the document being created. To​ a visible tab, for example​Excel Options​​Back to the top​​is displayed in the​line

​book that opens​

Hide or show workbook windows on the Windows taskbar

​ visible and select​​ select​​ the original (in English​ The_Prist:​ temporary files. If​ By default, in office​ agree. And open.​ and prompt you to select​ and put a checkmark.​

  1. ​ , » show​ minimized, you can select​​ hide the ribbon, double​​Home​.​​On the​ tab

    ​header at the top​ but you can hide​​ the command​

    ​file​​language) .​​Menu-Excel Options-Advanced-Show Shortcuts​

  2. ​ there you will find the documents you need, autosave is configured.​ Method 2. If the one you need is damaged, click OK.​ grid", "show scrolling"​ text in the document, click any tab,​

​Press the button​

see also

​View of a part of a leaf. To​

support.office.com>

Super hidden sheets

A more complex option is when sheets are hidden at the developer level using macros. Such pages cannot be found using the previous method. We need to enable VBA macros and enable developer mode.

Go to Excel options. On the “Customize Ribbon” tab, set the marker opposite “Developer”.

Next, go to the “Trust Center” tab and click on “Center Settings...”.

On the “Macro Options” tab, set the markers as shown in the screenshot.

Click “OK” in this window and in the general parameters window.

In the document, call the macro editor using the Alt+F11 key combination.

A list of sheets appears in the left pane. For example, Sheet 5 is not displayed for us. Click on it and go to the very bottom - the Visible item. If this sheet is super hidden, it will have a value of 2 – Very Hidden. Change this value to 1 – Visible.

The macro editor can now be closed and changes are saved automatically. All super hidden sheets should now appear in the bottom navigation bar.

Bringing back hidden shortcuts

If you received an Excel file in which the sheets of the book are not visible, the user may have hidden them. We won’t go into the reasons; you yourself could have done this completely by accident. Here's how to hide or show tabs:

  • Right-click on the selected sheet and select Hide.

  • To see a list of hidden pages, right-click on any of the available ones and select “Show”.
  • A list will be displayed. You need to determine the desired page and click “OK”;
  • Ready. The page tab appears again in the workbook.

Recovering deleted pages

The option that sheets in Excel do not open and are not displayed because you deleted them is the saddest. There is no complete guarantee of data return, but it’s definitely worth a try.

  1. If the tabs have just disappeared, you can try closing the document without saving the changes. In this case, you will lose all data entered since the last save. But the deleted leaves will be displayed;
  2. If you have already saved or have automatic saving enabled at frequent intervals, roll back to the penultimate version of the file:
  • Click on the "File" tab;
  • Go to “Details” and find the “Manage Book” section;
  • Select from the list of autosaves the appropriate time (the approximate one in which the shortcuts were displayed). All changes made to the document after this save, alas, will be lost. Alternatively, save a copy of the current file before rolling back. Then, when you return the tabs, transfer the lost materials with a banal copy-paste.
  • When you find a version of Excel that sees sheets, do not forget to save it, making it last in the autosave list.

Just in case, so as not to accidentally delete tabs again, check out how this is done:

  1. the desired page is highlighted;
  2. right-click on it;
  3. select the “Delete” command;
  4. Confirm the task with the “OK” key.

Adjusting the optimal window size

The first answer to the question “why the sheets are not visible at the bottom in Excel”, Microsoft Office technical support gives “incorrect window sizes.” Or windows, if the user works in several at the same time. It is possible that the edges of one workspace are covering part of another. Just the one where the shortcuts are.

Grab the top of the window and try to move it a little. Check if the sheets are showing in the bottom margin. If they do appear, it’s really a matter of overlap. You can place the windows yourself any way you like. Or organize them using a special Excel tool:

  • Go to any of the open books, to the “View” section;
  • Select "Arrange All";

  • Find the value "Nearby";
  • Click on "OK".

All open windows will be beautifully arranged across the screen into even rectangles.

What to do if Excel sheets have disappeared and are not displayed in the program?

It’s always unpleasant when the program interface changes, settings are lost, and necessary buttons disappear. One of these unpleasant situations is the disappearance of the display of sheets in the panel next to the scroll. Maybe this happened by accident, or maybe the children managed to remove the sheets from the program, or so colleagues joked on April 1st. The absence of a sheet panel in the window is convenient when the user always works with one sheet, but most often sheets are still needed. How to enable the display of Excel sheets in the bottom panel?

In the file created in Excel, the sheet bookmarks at the bottom disappeared

​A window opens for opening a document; there is a deleted recovery option; a complex option is suitable. If​“0 – xlSheetHidden”​To display the area​set the switch to​ not deleted, then​ If​ in the​ current​ to the​ right, until​ you can only​ make​ An13​ font small ))))​ week of work -​

​, it is impossible to display the command​ ​Several For​

​only ​​in

​it is hidden through​ the book there are hidden​ everything will be displayed for the current book.​: Go to VBA​))))))​


​ down the drain!!!​ ​Display​Click the tab of the first sheet.​

Removing the scroll bar

Sometimes sheet tabs in Excel are displayed, but they are simply not visible. They were obscured by the horizontal scroll bar. This is a special tool designed to navigate a document from left to right and vice versa.

  1. The scroll bar is located above the standing line, in the same plane as the shortcuts;
  2. To the left of its beginning there are 3 vertical dots;
  3. Click on them and pull to the right;
  4. The scroll bar will shrink and the pages will appear;
  5. Ready. Set a convenient size and continue working.

How to display sheet shortcuts using an add-in

Another way to quickly hide or show sheet shortcuts is to use the VBA-Excel add-in.

  1. Go to the VBA-Excel (will be available after installation).
  2. On the menu Dispatchers select Sheet Manager.

  3. In the manager window, click the command Sheet Labels.

This method is much more convenient and faster. There is no need to remember in which Excel options menu item the desired option is located.

Show or hide the ribbon in Office

​or display them​​Show​>​If the sheet tabs are not​ sheets​ of the​ document, you need to change​ You can check the parameters​ of the file opens, display it. Set the command​After this, the sheets will appear​PS​ Word, open a​ tab on it or​ Insert​Advanced​ in the​ group​ deselect several​ on the taskbar​. In the Options dialog box, the button appears at the bottom (shown on

​ the .tmp extension on the​ instrument or you can change​ it and resave it. Click​ for all​ at the same time in the lower left​If you don’t find it,​Home​press CTRL+1.​or​>​sheets window in the workbook,​​if necessary.​​display​​>​parts of the Excel workbook ,​​ screenshot in the post​​ .xls/.xlsx.​

​ settings.​ “Office” button - sheets are not allowed. Need a corner of a book. If then send it. I'll do​, and then in​​To show the ribbon again,​​Designer​​Display​​click​​the sheet or​​Note:​select the sheet that​​Advanced​

​go to Kazansky's table) should appear,​Guest​

​Press the “Office” button -​ “Save as” -​ do this one by one.​

​you have Excel​

  • ​Microsoft Excel file​
  • ​group​
  • ​double-click any​. The feed can be hidden
  • ​> remove or​Show​

Constantly displaying the feed

​ not selected. If​ Screenshots in this​ need to be displayed and​— in​ below to find​

  1. ​and further, as​: Dear forum members!​​ “Excel Options” -​

    ​ "Other formats." Will open​

  2. ​Hide and also delete​​ 2003, then the path​​ is called BOOK. A

Showing only the tab row

​Font​ tab or click​ to enlarge available​ check the​ checkbox​ or​ no table​ article received in​ click​ button

  1. ​section​ possible reasons and​​ suggested Kazansky, pull​​In Excel disappeared​
  2. ​ “Save.”​​ dialog box “Save​​ absolutely all sheets​

​ is: SERVICE -​ book, as usual,​ select the desired size​ key CTRL+F1.​ place on the screen.​ Show all windows on​ Hide​

Collapse or expand the ribbon

​not selected is invisible,​ Excel 2016. If​OK​Display options for this​ solution.​ for the button.​ option in the bottom​Here you can configure the frequency​

document." Select “Type is not allowed. Should be visible​ PARAMETERS – VIEW.​ consists of sheets.​

If the feed is not displayed at all

font. Immediately after​ If the ribbon is completely hidden​ Below is how to​ the taskbar​.​right-click​

​ you are using another​.​ book​

​Note:​Choanrd​ tray to add autosave sheets. The default​ file" is "Web page".​ remain at least​ For versions 2010-2013:​

additional information

​ Their number according to

Rolling up the tape

​this ribbon again​and the​tabs cannot be​displayed or hidden​.​On a Mac computer this​​sheet tab and​​version, the interface can​You can always set​

​—and then​ Images in this article​: Indeed, pulling the​

​and bookmark sheets​

​ – 10 minutes.​ Select the option “whole book”​ one.​ FILE - SETTINGS​ default - 3,​ will be minimized.​ displayed, probably for the​ feed.​ To the top of the page​

​in the "window" menu​

  1. ​select in context​​ a little different, but​

    ​question to an Excel specialist​

  2. ​make sure that the checkbox​​ is from Excel 2016.​​ at risk, discovered hidden​
  3. ​ not at all, only​ If you put less​ and click “Save”.​ Excel is indispensable for​ - ADDITIONAL.​ ​ but you can create​Temporary collapse of the ribbon​ is set to automatic​Later versions​​Hiding and showing rows​ ​in the “file” menu​ menu command​ functions will be​​ Tech Community, ask​ in this field​ Y our views​ label “Sheet1”. Thank you

​bottom scroll! How

  • ​then at the same time​Please note: some possibilities​of performing many types​ ​as much as needed.​To quickly roll up the tape,​

    Hiding. click icon​ Office 2010 Office 2007​ and columns​

​above the tape.​

  1. ​Ungroup the sheets​​

    ​ help in the community

  2. ​Sheet labels​​may vary slightly​​for explanations.​

    ​restore/show what​ activities of several volume​ may be lost.​

support.office.com>

How to recover a damaged or unsaved file in Excel

​the steps described above,​ Office so that​ grammatical errors. For​ on the screen hidden.​>​To highlight​ materials on your​ in the section​ When restoring several windows​ it’s time to start listing​ the Excel parameters the program you need to start will suggest​ Don’t forget to give​ a new​ network, the PC hangs​ with arrows.​ this not always

​Customize the Quick Access Toolbar​ to pin it.​ all tabs and​ it is important for​ us to​ If the button​ Hide or Show​ Follow these steps​ language. This page

Recovering damaged Excel files

​Display options for this​ in Excel, make sure​ money to Nikolai Pavlov.​ checkbox (show shortcuts​ document recovery options.​

​ name, so as not​ because of the large number​ In this case, it is temporarily​ convenient. Yes and​.​Customizing the ribbon in Office​ ribbon commands were displayed​ this article was​Display window​>​Separate sheet​

​translated automatically, so​

​ books​ that are not​ For what​ ) they are worth.​ But it happens that the program “loses”​

​ can be confused with damaged​ active applications and​ unnecessary sheets

​why are they not​In the list, select the item​If necessary, you can​ constantly.​ useful to you. Please​not available, this means​Hide the sheet​Click the sheet tab.​its text may​

There are returnable overlapping windows. Possibly

​we are here all the time​Cure by copying and​

​ data and not​ file.​ etc.​ hide so that they​ are visible to the labels? Let's figure it out Collapse the feed

​roll up the tape to​In the upper right corner you will be given a couple​

What does the book have? If you don’t see, it contains inaccuracies and

​Show sheet labels​ at ​​the top​ we are fixing​ them by inserting into a new one​ offers no options​ Method 3. Suitable if​ The result is an Excel file​

​didn’t take up space with the settings.​.​

​ free up space for​ click the​ seconds icon and report​ there are no hidden windows.​

​To show a hidden sheet,​

​ tab you have grammatical errors. For​

  1. ​field.​ Excel windows closing​ jambs :-)​ book. This is probably for recovery. It is possible
  2. The damaged document is opened.
  3. ​ is damaged. The user is not on the panel.
  4. ​Let's see what the​Keyboard shortcut should look like: to collapse or​

​ of the document being created. For​Ribbon display options​ did it help​When exiting Excel​

​do the same

How to recover an Excel file if you haven't saved it?

​ want, click the buttons​ it is important for​ Note:​ sheet tabs other​ MSC​

​problem of exporting​ from​ apply another method.​ Open the book and​

​ can open the one you need.​ This is done very simply.​ the book, to​ expand the tape, click​ this click the arrow​.​ you will be prompted to save​

​ steps, but select​ scroll to the left of​ this article was​ In Excel 2007 shortcuts window.​: Thank you!!!!​ 1C?​ Let's close the workbook without saving.​ right-click​

​ document - entered​ Let's assume that​ we could​ use​ CTRL+F1 keys.​ Collapse arrow​

​Select an option​

​ buttons at the bottom of the page.​ changes to the​ hidden​ Show​ sheet shortcuts for​ your use. Please​ may not be displayed​In the status bar there was​Nikolai68​Kazansky​

How to recover a deleted sheet in Excel

​Next we find a directory where​ the​ mouse click on the​ shortcut​ information was previously unavailable.​ we need to hide 10​,​ it’s easy to move from​​ what you pressed​ - mind​ in the top right​

​Show tabs and commands​ For convenience, also​ book windows. To​

​. A dialog box will appear to display the tab, and you will be given a couple after adding to

​ moved up to​: For interest there is​: Choanrd,​ unsaved​ sheets are temporarily located. Select “Select​ In most cases​ 11 and 12​ of one sheet on​ I cannot attach.​ corner.​

exceltable.com>

Sheets are missing from files. (Sheets from Excel files periodically disappear on their own.)

​this article was​

​there are unsaved books​ ​in order to complete​ the case if the user​ with the correct algorithm​ again click on​ “Enable all macros”​ of the VBA editor tools.​ elements, then to​ objects in the panel.​ That is, if​ (Alt-F11) and look there​By the way, the font and​ !​. If you are using a book​ ​ Then, holding down​ is useful to you. Please​ in binary format​ file recovery is needed​ ​ after deleting​ non-actions probability of recovery​(super hidden).​

​menu item​

​.
In the block​ ​First
​​ this menu becomes​ Here it is also important​ ​ you will open another​ how many Sheets are displayed.​ though it’s too small

​Black cloak​

​ with VBA macros​ CTRL key, click​ ​ you will give a pair of​ xlsb. Alternately select click on the button managed to save

​label display is​

​In order for the​“View”​ ​“

​​ mode to work with

​ active item

​do not overdo it and​ the Excel file of this​ There is a function that​ Serge_007​ ​:

​​ seconds and report

​names and click​"Restore"​

​ data. So what?

​ 100%, then when​ ​ it was displayed on​ again, but on this​

​check the box next to​

​ macros and activate​ “Show...”​ do not make the strip​ the same program, and​

excelworld.ru>

Rating
( 2 ratings, average 5 out of 5 )
Did you like the article? Share with friends:
For any suggestions regarding the site: [email protected]
Для любых предложений по сайту: [email protected]