Viewing spreadsheet documents

Navigating spreadsheets. As in the standard Microsoft Windows interface, the spreadsheet document window always contains only a part of the spreadsheet document. To select a cell in a visible area, click it. To view other parts of the spreadsheet document, use the scroll bars.

To scroll a large document, hold the wheel button and select the scrolling direction with the pointer. The scrolling speed depends on the distance between the pointer location and the location where the wheel button was pressed (specifically designated).

Managing a spreadsheet view. To configure the view of various areas and components of a spreadsheet document (column and row headers, grid, and so on), on the main menu, point to Table, point to View, and then click the appropriate menu command. This turns menu commands on or off.

Command 

Description

Dock Table

Freeze the top rows and left columns of a spreadsheet document so that they are always visible when the document is scrolled.

Show Grid

Show or hide spreadsheet grid (thin lines that separate cells).

View Headers/Footers

Show or hide row and column headers.

View Groups

Show or hide groups (the areas to the left of the row header or above the column header).

Edit

Allow or deny spreadsheet document editing.

Show Comments

Show or hide comments.

Black and White View

Enable or disable colors specified in the spreadsheet document. When the command is turned on, all the colors are defined by Microsoft Windows settings.

Page view mode

Show or hide the minimum number of rows (depends on the amount of data in the spreadsheet), print area, and page breaks.

Scale

Scale the document.

Scaling spreadsheets. To scale a spreadsheet document, on the main menu, point to Table, point to View, point to Scale, and select scale.

You can also scale a spreadsheet by rotating the wheel button while holding down Ctrl. Rotate the wheel forward to zoom in or backward to zoom out.

Freezing rows or columns. You can freeze the top rows and left columns so that they are always visible when you scroll a spreadsheet document. This is convenient if you are viewing a large table.

To freeze the top rows, select a row and then, on the main menu, point to Table, point to View, and click Dock Table. This freezes all the rows above the selected one. 

To freeze the left columns, select a column and then, on the main menu, point to Table, point to View, and click Dock Table. This freezes all the columns to the left of the selected one. 

To freeze both rows and columns, select a cell and then, on the main menu, point to Table, point to View, and click Dock Table. This freezes all the columns to the left of the cell and all the rows above the cell.  

To unfreeze rows and columns, click Dock Table again.

Making spreadsheets read-only. To make a spreadsheet document read-only, on the main menu, point to Table, point to View, and click Edit (uncheck this menu item).  

If a cell contains text that does not completely fit the visible area, move the pointer over the cell to view the text in a tooltip. If the text is too large to be displayed in a tooltip, only a part of the text is displayed. While you are editing this text, a tooltip is not displayed, as long as you do not move the pointer. 

Scrolling spreadsheets. Use the standard Microsoft Windows scrolling methods. If your mouse has a wheel button, to scroll vertically, rotate the wheel. To scroll horizontally, hold down Shift and rotate the wheel.

Next page: Names

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.