Organizing Sheets

There are three ways to navigate and view the sheets in a workbook: the tabs at the bottom of the workbook, the filmstrip, and the sheet sorter. The tabs are useful for quickly navigating between a small number of sheets. If your workbook has a large number of sheets, you may find that the sheet sorter makes it easier to navigate them all.

Sheet Tabs

Each sheet, whether worksheet (view, dashboard, or story) is represented as a tab along the bottom of the workbook. Select any tab to open the corresponding worksheet.
In the bottom right corner of the application window, there are several controls that you can use to advance through each sheet or quickly jump to the first or last sheet in the workbook. These controls are only available when there are too many sheet tabs to show across the bottom of the application window.

You can also navigate between sheets using the window menu or move through the multiple worksheets by pressing Ctrl + F6, or pressing the Right or Left Arrow keys on your keyboard.
To navigate through multiple worksheets, a worksheet tab at the bottom of the workbook must be selected.
Navigating within a story is a different matter—there, you use the Navigator to move between story points. See Updating a Story.
To make it easier to identify and group sheets, you can assign each sheet tab a color. Right-click the tab and select Color. You can select from seven different colors. Selecting None resets the color back to the default.
In addition to color, you can use the right-click menu to specify commands that apply to the selected sheet. For example you can create new sheets, duplicate sheets, copy formatting, and delete the sheet entirely. Hold the control key when selecting sheets to select and apply settings to multiple sheets all at once.
Colors only display when viewing the sheets as tabs. The colors are not associated with the filmstrip and sheet sorter.

Filmstrip

Similar to the sheet tabs, the filmstrip displays along the bottom of the workbook. However, instead of sheet names, the filmstrip shows a thumbnail image of each sheet. The filmstrip is useful when you are using Tableau to present your analysis and works well when you are working in Presentation mode.
Open the filmstrip by clicking the arrows on the bottom right corner of the workbook. Just like with the tabs, select the thumbnail image for the sheet you want to open. You can right-click the images to specify commands that apply to each sheet.
Note: When viewed from a Retina display, workbooks that are created on a standard resolution device will show only the first thumbnail in the filmstrip in high resolution. To display all thumbnails in the filmstrip in high resolution, resave the workbook on a computer with Retina display.

Sheet Sorter

The sheet sorter shows all sheets in a workbook as thumbnail images on a single page and is similar to the slide sorter in Microsoft Power Point. The sheet sorter is useful when you have a large number of sheets in a workbook. Open the sheet sorter by clicking the sheet sorter tab in the upper right corner of the workbook.

From the sheet sorter you can drag and drop to reorder the sheets, create new sheets, and duplicate or delete existing sheets. Right-click a sheet to see these commands. You can also right-click to refresh the thumbnail image of a particular sheet or Refresh All Thumbnails at once.

No comments:

Post a Comment