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 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 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:
|
Joins and Relates | Six tools are available to establish and remove joins and relates:
|
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.