Interact with a table

There are many ways to interact with tables in an open table view.

Move to another cell

To move to another cell in the table view, click a specific cell or use the keyboard to move one cell at a time. These keystrokes are described in the following table:

KeystrokeAction

Press Enter

Move to the next row in the same column.

Press Tab or Shift+Tab

Move forward or backward one cell along a row.

Press Up arrow, Down arrow, Left arrow, or Right arrow

Move one cell in the direction of the arrow key.

Press Alt+Ctrl+Up arrow

Move to the first row in the same column. Alternatively, click the Move to Beginning button Move to start of table at the bottom of the table.

Press Alt+Ctrl+Down arrow

Move to the last row in the same column. Alternatively, click the Move to End button Move to end of table at the bottom of the table.

Press Ctrl+G

Display the Go To Row Number controls and move to a specific row in the table.

Press Ctrl+F

Display the Find and Replace controls and move to the first instance of a found value.

A complete list of keyboard shortcuts is also available.

Select and highlight fields and rows in a table

You can use table toolbar tools to add or calculate fields and modify a selection. When tables are viewed in the Show Selected Records view, you can highlight within the selection. Stand-alone tables have an additional option to insert multiple rows.

Fields and Selection

In a table view, the Fields and Selection groups are always available; however, the Fields group is unavailable if the data source is read-only. The following tools are always present on the table toolbar:

ToolDescription

Add Field Add Field

Add a new field to this table. The fields view of the table opens.

Calculate Field Calculate Field

Set the value of a new or existing field by specifying a calculation expression. The Calculate Field tool opens, prepopulated with the field that has focus if that field is editable. Click the field header to highlight the entire column and give the field focus.

If any of the rows in the table are selected, only the values of the selected rows are calculated.

Select By Attributes Select By Attributes

Select features by their attribute values.

Zoom To Selection Zoom To Selection

Center the map on the features in the selected rows.

This option is only available in tables that were opened from a map or scene.

Switch Selection Switch Selection

Reverse the current selection set to deselect all selected rows and select all the deselected rows. For example, if all records are selected, Switch Selection removes the selection. If no records are selected, Switch Selection selects all records.

Clear Selection Clear Selection

Deselect all selected rows.

Delete Selection Delete Selection

Delete all selected rows from the table.

Copy Selection Copy

Copy selected rows to the clipboard.

Highlight records in a table

You can highlight records in a table to work with a subset of selected records. When in the selected view of a table, a third group named Highlighted appears on the toolbar. These tools are described in the following table:

ToolDescription

Unselect Highlighted Unselect Highlighted

Remove the highlighted rows from the current selection set.

For example, if you have five selected records and three highlighted records, click Unselect Highlighted to remove the three highlighted records from the selection set. In this example, two selected records remain.

Reselect Highlighted Reselect Highlighted

Update the current selection set to select the highlighted records in the Show Selected Records view only and deselect all the other records. Use this to refine the selected set by limiting it to the records that are highlighted.

Zoom To Highlighted Zoom to Highlighted

Center the map on the features in the highlighted records.

This option is only available in tables that were opened from a map or scene.

Switch Highlighted Switch Highlighted

Switch the highlighted records. For example, if all records are highlighted, Switch Highlighted removes the highlight, but the records remain selected. If no selected records are highlighted, Switch Highlighted highlights all selected records.

Clear Highlighted Clear Highlighted

Highlight is removed from all currently highlighted records, but the records remain selected.

Delete Highlighted Delete Highlighted

Delete all highlighted records from the table.

Copy Highlighted Copy Highlighted

Copy all highlighted records to the clipboard.

Insert and duplicate rows

You can add more rows to editable stand-alone tables by inserting new rows or duplicating an existing row.

Insert rows

Click the Insert Rows button Insert Rows to expand the Insert Rows dialog box. Provide the number of rows to add and click Create or press Enter to add new empty rows to the bottom of the table. The rows are selected, and the first newly added row has focus.

Note:

  • You can add a maximum of 1,000 rows at one time.
  • If a definition query is being used, the new rows may not appear.

Duplicate a row

Right-click the row header and click Duplicate Row Duplicate Row to create a copy of a feature or record of attributes at the bottom of the table. It is selected.

Use the table menu

Click the Menu button Menu at the end of the table toolbar to access additional table controls and display options. The following table describes these options:

OptionDescription

Show Field Alias

Switch display between (database) field name and alias. By default, the field alias name is shown.

Show All Fields

Show all fields. All hidden fields become visible so that they are available in the table window as well as on other dialog boxes.

Reset Field Order

Reset the fields to be in database field order.

Fields View Fields

Show the fields view for the current table.

Show domain and subtype descriptions

Switch display between descriptions and coded values for domain and subtype fields.

Contingent Values

Filter the display of fields that contain contingent values. The filter is available only when contingent values are present in the table.

Three options are available:

  • Contingent value fields—Show all fields that have contingent values defined and hide other fields.
  • Highlight invalid values—Highlight fields that have invalid contingent values.
  • Auto-update other fields—When a value is changed, values for other fields are automatically set when only one match is valid.

Joins and Relates

Six tools are available to establish and remove joins and relates:

  • Add Join Add Join—Join data to this layer or stand-alone table based on a common attribute.
  • Remove Join Remove Join—Remove joined data from the current table.
  • Remove All Joins Remove All Joins—Remove all joined data from the current table.
  • Add Relate Add Relate—Relate data to this layer or stand-alone table based on a common attribute. Unlike a join, a relate does not append data to the table.
  • Remove Relate Remove Relate—Remove a relate from the current table.
  • Remove All Relates Remove All Relates—Remove all relates from the current table.

Related Data Related Data

Select from the list of relationships to view data related to the table's selection. The option is only available when a valid relationship is present.

Select related records

Enable this option to simultaneously select related data when selecting rows in the table. If the table is either time- or range-aware, the same filter is applied to the related table.

Find and Replace Find and Replace

Open the Find and Replace control to search for data in an attribute table and update it.

Go to row number Go to Row

Open the Go to row number control to move to a specific row number in the table.

Open Data Engineering Open Data Engineering

Open Data Engineering to explore, visualize, and prepare the data.

Export Export Table

Export the current table to a new table.

Change table appearance

You can change the appearance of an active table by changing the row and column header heights. Appearance changes are saved with the project. Alternatively, you can change the appearance of all tables by changing the default font and size and the row and column header heights from the project options.

Follow these steps to define the size of rows and column headers in a table:

  1. On the Table tab of the ribbon, in the Appearance group, click the Table Appearance button Table Appearance.
  2. Under the Column Header Height heading, choose Single, Double, or Triple.

    Single means space equivalent to a single line of text. Double means twice the height of the font and contains the space equivalent to two lines of text. Text in a column header is centered vertically.

  3. Under the Row Height heading, choose Single, Double, or Triple.

    Data in a cell is aligned to the top.

The table updates to display the new spacing.

Related topics