Navigate a workbook in Excel Services
A workbook author can create and customize a Microsoft Office Excel Web Access Web Part in many ways. Sometimes, you may view only a selected range or named item in a workbook, and may not need to navigate the workbook because all of the information is displayed, such as in a specific chart or named range of cells. Sometimes, the workbook contains multiple worksheets, or a worksheet contains more information than can fit in the current display size of Microsoft Office Excel Web Access. In these cases, you can easily navigate to a different worksheet or navigate to another part of the worksheet.
What do you want to do?
Navigate to another worksheet
At the bottom of Excel Web Access, under the row headers, do one of the following:
If there are only a few worksheets, click a sheet tab.
If there are many worksheets, and you don't see the worksheet that you want, scroll through the worksheet by using the adjacent scroll bar, or by clicking one of the adjacent Sheet tab navigation buttons, and then click a sheet tab.
Navigate within a worksheet
If there are a large number of rows and columns, Excel Web Access displays only a portion of these rows and columns in a scrolling page. By default, 20 columns and 75 rows are displayed in a scrolling page. However, a workbook author can change the number of visible rows and columns to display in Excel Web Access by setting the Rows or Columns properties. For more information, see Excel Web Access Web Part custom properties.
Do one or more of the following:
If the worksheet contains more cells outside the current view, use the scroll bars.
Click the Page Left, Page Right, Page Up, or Page Down button arrows to navigate to the next scrolling region in a large worksheet.
To page by a specific number of rows or columns, or to page to the top row, bottom row, leftmost column, or rightmost column, click the arrow next to each Page button and then select an available command.