Microsoft Office Tutorials and References
In Depth Information
Navigating Workbooks and Hyperlinks
Navigating Workbooks and Hyperlinks
When you view a workbook in Excel client, there are two primary ways to navigate within a worksheet
and workbook:
Scrolling within a worksheet
Switching between sheets
When you view a workbook with Excel Services in the browser, the same is true, but the implementation
is slightly different. In the first section, you learn the basic navigation of a worksheet and workbook in
the browser. You then take a look at switching between items in a workbook, using hyperlinks to
navigate workbooks, and expanding and collapsing grouped rows and columns.
Scrolling Within a Worksheet
By default, EWA displays only the first 20 columns and 75 rows of a worksheet in the browser. This is a
performance optimization that minimizes the size of the HTML file transferred across the wire. Because
of this, the scroll bars only let you scroll within the 20-by-75 region of the worksheet. If you want to
scroll to a different area in the worksheet, use the page scrolling controls on the toolbar.
The page scrolling controls appear only when the worksheet has data in the range beyond the first 20
columns or 75 rows, in which case there is an arrow for each scroll direction: left, right, up, and down. If
there is nowhere to scroll in a particular direction, then the corresponding arrow is disabled. Therefore,
assuming you load the worksheet with the first row and column in the top-left corner, the left and up
arrows are disabled. Because you cannot edit a cell in Excel Services, the scrollable range is defined as the
used range within a worksheet.
Pressing the left or right arrows scrolls the workbook by 20 columns left or right. Pressing the up or
down arrows scrolls the workbook to the next or previous 75 rows accordingly. Each of the arrow
buttons is also a split-button, and you can use it to open a menu for scrolling explicitly by 500, 200, 100, 20,
10, 5, or 1 columns or rows. You can also scroll directly to the first or last column or row.
The default setting for how many rows and columns are displayed can be changed. The section, “Excel
Web Access Interactivity Settings,” later in this chapter, describes how to do this.
When you open a workbook in Excel Services, it displays the same worksheet that it was on when you
saved it in Excel client, and with approximately the same range that was displayed on the client. For
example, if you publish a workbook with an active cell in row 100 on worksheet two, it comes up in the
browser with that cell in view.
Try It Out Navigating a Worksheet in the Browser
To navigate a worksheet in the browser, follow these steps:
1.
Open the original Sales Report.xlsx workbook in Excel client and publish it to the server. Ensure
that you have the Open In Excel Services option checked so that the browser opens with the
workbook displayed.
Search JabSto ::




Custom Search