Discover the world with our lifehacks

How do I view all sheets in Excel 2010?

How do I view all sheets in Excel 2010?

The Show sheet tabs setting is turned off. First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced—in under Display options for this workbook—and then ensure that there is a check in the Show sheet tabs box.

How do I show a list of sheets in Excel?

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!

How can I get a list of all sheets?

A. Yes, you can create a list of your Excel workbook’s worksheet names as follows. From the Formulas tab, select Defined Names, Define Name to launch the New Name dialog box pictured below.

How do I view hidden sheets in Excel?

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.

How do I view tabs side by side in Excel?

View two worksheets in the same workbook side by side

  1. On the View tab, in the Window group, click New Window.
  2. On the View tab, in the Window group, click View Side by Side .
  3. In each workbook window, click the sheet that you want to compare.
  4. To scroll both worksheets at the same time, click Synchronous Scrolling.

How do I unhide hidden sheets in Excel?

To unhide a sheet, simply right-click any sheet’s tab and select Unhide. This reveals the Unhide dialog box as shown below. Pick the hidden sheet and click ok.

How do you unhide sheets?

Unhide Worksheets Using the Ribbon

  1. Select one or more worksheet tabs at the bottom of the Excel file.
  2. Click the Home tab on the ribbon.
  3. Select Format.
  4. Click Hide & Unhide.
  5. Select Unhide Sheet.
  6. Click the sheet you want to unhide from the list that pops up.
  7. Click OK.

How do I view multiple sheets in Excel?

Can you view multiple tabs in Excel?

View multiple sheets in one workbook Open the workbook that you want to view. On the Window menu, click New Window. Switch to the new window, and then click the tab for the sheet that you want to view. Repeat steps 2 and 3 for each sheet that you want to view.