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.

 Note    Alternatively, you can display Excel Web Access in a full Web page, find text, number, and date values, or open the workbook in Microsoft Office Excel. For more information, see Display the Excel Web Access Web Part in Web Browser view, Find text, numbers, and dates in Excel Services, and Open a workbook or snapshot in Excel from Excel Services.

What do you want to do?


Navigate to another worksheet

 Note   You only see the worksheet tabs if the workbook author has made them visible when the workbook was saved from Excel and has not set the Excel Web Access Named Item to Display property. For more information, see Microsoft Office Excel 2007 Help, and Excel Web Access Web Part custom properties.

  • 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.

Top of Page Top of Page

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.

 Note    The top, beginning cell of what is initially displayed is based on the location of the selected cell when the workbook was saved from Excel.

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.

Top of Page Top of Page

 
 
Applies to:
SharePoint Server 2007