If you select all the rows and click ‘unhide’ and they do not show up, then they are filtered and not hidden. Click the Sort & Filter button on the Home tab of the ribbon and then click ‘clear’. On the Home tab, click on the Format icon Choose Hide & Unhide from the dropdown menu then select Unhide Rows.

To unhide a worksheet, right-click on any visible tab and then click Unhide. In the Unhide dialog box, click the sheet you want to unhide and then click OK.

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Columns. Now you should be able to see column A in your Excel spreadsheet.

How to Display Sheet Tabs in Excel 2010

1. Open Excel.
2. Click File.
3. Choose Options.
4. Select the Advanced tab.
5. Check the box to the left of Show sheet tabs.
6. Click OK.

Hide or unhide a worksheet

1. Select the worksheets that you want to hide. How to select worksheets.
2. On the Home tab, in the Cells group, click Format > Visibility > Hide & Unhide > Hide Sheet.
3. To unhide worksheets, follow the same steps, but select Unhide.

To unhide the ribbon temporarily, click at the very top of your workbook. To get the ribbon back permanently, click the Ribbon Display Options button in the top-right corner and choose the Show Tabs and Commands option. This will show the ribbon in the default full view with all the tabs and commands.

Find the appropriate Excel file, select it and then select “Home” on the menu bar. Select “History” to review the various versions, searching for the most recent. Open the file. Once opened, select “Restore” to reopen the missing worksheet.

All you need to do is follow these steps:

1. Choose Options from the Tools menu. Excel displays the Options dialog box.
2. Make sure the View tab is selected. (See Figure 1.)
3. Make sure the Status Bar check box is selected.
4. Click on OK.

Excel: Right Click to Show a Vertical Worksheets List

1. Right-click the controls to the left of the tabs.
2. You’ll see a vertical list displayed in an Activate dialog box. Here, all sheets in your workbook are shown in an easily accessed vertical list.
3. Click on whatever sheet you need and you’ll instantly see it!

Click Home > Format > Hide&Unhide > Unhide Sheet.

The fastest way to detect hidden sheets in Excel is this: right-click any sheet tab and see if the Hide… command is enabled or not. If it is enabled, click it and see which sheets are hidden. If it is disabled (greyed out), the workbook does not contain hidden sheets.

To add more tabs, simply single-click next to the first document tab to create another one. If you open an existing document, it will just add it along side any other documents you currently have open.

In Excel, you can display the Activate dialog to view all sheet tabs. Right click at the sheet navigation controls |< < > >| in the Sheet tabs bar, then you can view the sheet tabs in the popped out pane.