Entering and Editing Table Data

You can enter and edit table data in various ways, depending on where you are in the system. Entering data in table cells is often like entering data in fields. Tables are simply rows and columns of information that you can view and edit.

About Table Cells

Table cells can be editable or view-only. You can change the cell contents of an editable cell, but you cannot change the contents of a view-only cell.

As you move from cell to cell and enter data, cells can also take on the following characteristics:

This type of cell...

Looks like this..

And means...

Focus cell

this is the currently selected cell.

Active cell

the cursor is active in an editable cell.

Navigating Within Tables

The following table describes how to navigate from cell to cell within a table:

To move...

Press...

the cursor to the next editable cell

Enter or Tab

the cursor into any cell, editable or not

the Arrow keys

to the previous viewable page of information

Page Up

to the next viewable page of information

Page Down

the cursor to the left-most cell in a row

Home

the cursor to the right-most cell in a row

End

the cursor to the top cell in a column

Ctrl and Home

the cursor to the bottom cell in a column

Ctrl and End

backwards through the editable fields

Shift and Tab

Searching for Data Within Tables

You can search a table column for data contained within that column, but you cannot search an entire table.

To search a table column:

  1. Right-click on the column and select Search from the list of options. The Search prompt displays.

  2. Enter the data you want to search for and click OK. The Closedfocus cell moves to the cell that contains the matching data.

Note: If the data you enter is contained in more than one cell, you are prompted to choose from a list of matches.

Entering and Editing Data Within Tables

The following table describes how to enter and edit data in table cells:

To do this to a cell...

Do this...

enter data in a cell

position the cursor in the cell and begin typing.

change data in a cell

position the cursor in the cell and begin typing.

cut data from a cell

double-click the cell to make it active, and then press Ctrl and X.

copy data from a cell

double-click the cell to make it active, and then press Ctrl and C.

paste data into a cell

double-click the cell to make it active, and then press Ctrl and V.

delete a cell's contents

position the cursor in the cell and press Delete or the Space Bar.

See Also:

Working with Table Columns

Tables Overview