# Overview

Worksheets contain the elements, such as the cell grid area, which provide the principal work entities for &gnum; users. The worksheet grid area allows users to enter data, develop analyses of these data, and display both data and results. Worksheets also contain graphical elements such as graphs and widgets. The worksheets are themselves grouped into a workbook which will be stored in a &gnum; file. The manipulation of workbooks is explained in while the material below explains the manipulation of worksheets.

Worksheets contain both working elements and metadata elements. The working elements include the data contents of cells in the grid area, cell comments, cell formatting, and sheet objects, such as graphical plots. The metadata include the worksheet name and worksheet settings controlling the visual appearance of the worksheet or the display of the worksheet.

This section explains the main ways to manipulate &gnum; worksheets. explains how to navigate the worksheet to change the area which is displayed and change the currently selected area. presents several alternative settings which alter the display of cell contents, of the grid area, of the worksheet as a whole or of &gnum; itself. explains how to alter settings which affect all the contents of the worksheet such as the status of the content protection mechanism. gives a brief explanation of the print settings which apply specifically to each worksheet; a more complete explanation of the print settings is given in . Finally, explains how the entire collection of worksheets can be manipulated so as to add, duplicate, delete or re-order the worksheets within a workbook.

# Worksheet Navigation

&gnum; worksheets can be conceived of as a single, continuous, two-dimensional grid of cells. However, &gnum; cannot display the entire grid at once but only shows a portion of the worksheet. Since only a portion of the worksheet can be seen at any particular time, &gnum; provides users with several ways to change the portion of the worksheet that is displayed. explains the various ways that the display window can be moved to a different section of the worksheet grid, while , further below, explains more powerful methods to re-organize the display of the cell grid area.

## Moving Around a Worksheet

## Moving the Selection

# Worksheet Display

The display of each worksheet can be controlled by several settings and configurations. The worksheet, conceptually, consists of a single continuous two dimensional grid of cells arranged in rows by columns, and &gnum;, by default, displays a small portion of the worksheet area as a continuous region.

A worksheet is created with the number of rows and columns specified by the preference setting that can be adjusted on the Windows tab of the Preference Dialog (see );

The maximum number of supported rows in a sheet is 16,777,216 and the maximum number of supported columns is 16384. The numbers of rows and columns of a sheet must always be powers of 2.

The size of an existing sheet can be increased through the Resize Sheet dialog accessible through the sheet tab context menu (see ) or the Sheet submenu of the Edit menu (see ).

## Appearance

### The cell content appearance

This section has not yet been written.

#### Displaying Formulas or Results

This section has not yet been written.

#### Displaying Zeros or Blank cells

This section has not yet been written.

### The grid area appearance

This section has not yet been written.

#### Displaying Gridlines

This section has not yet been written.

#### Displaying Row and Column Headers

This section has not yet been written.

### The workbook appearance

This section has not yet been written.

#### Zoom: Changing the Scale of a View

This section has not yet been written.

#### Full Screen Mode

This section has not yet been written.

#### Displaying Workbook Tabs

This section has not yet been written.

#### Displaying Grid Area Scrollbars

This section has not yet been written.

## Grouping Rows and Columns

## Display Panes

# General Settings

## Content Protection

# Print Settings

# Managing Worksheets

This section has not yet been written.

## Alternative Approaches

This section has not yet been written.

### Using the menu

This section has not yet been written.

### Using the mouse

This section has not yet been written.

### Using the context menu

This section has not yet been written.

### Using the sheet management dialog

This section has not yet been written.

## Adding a Blank Worksheet

This section has not yet been written.

## Duplicating a Worksheet

This section has not yet been written.

## Copying or Pasting a Worksheet

This section has not yet been written.

## Renaming a Worksheet

This section has not yet been written.

## Reordering Worksheets in a Workbook

This section has not yet been written.

## Changing the appearance of Worksheet Tabs

This section has not yet been written.

## Deleting Worksheets

This section has not yet been written.