Interact with a table—ArcGIS AllSource

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:


Keystroke	Action
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 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 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:


Tool	Description
Add Field	Add a new field to this table. The fields view of the table opens.
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 features by their attribute values.
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	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	Deselect all selected rows.
Delete Selection	Delete all selected rows from the table.
Copy Selection	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:


Tool	Description
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	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	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 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	Highlight is removed from all currently highlighted records, but the records remain selected.
Delete Highlighted	Delete all highlighted records from the table.
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 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 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:


Option	Description
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	Show the fields view for the current table.
Show domain and subtype descriptions	Switch display between domain descriptions or subtype names and their coded values.
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 —Join data to this layer or stand-alone table based on a common attribute. Remove Join —Remove joined data from the current table. Remove All Joins —Remove all joined data from the current table. 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 a relate from the current table. Remove All Relates —Remove all relates from the current table.
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	Open the Find and Replace control to search for data in an attribute table and update it.
Go to row number	Open the Go to row number control to move to a specific row number in the table.
Open Data Engineering	Open Data Engineering to explore, visualize, and prepare the data.
Export	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:

On the Table tab of the ribbon, in the Appearance group, click the Table Appearance button .
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.
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.

Feedback on this topic?