You can specify as your Scoping Method for a Named Selection.
Doing so displays the Worksheet window. By default, this window displays below the Geometry pane in Mechanical. Worksheet data entries define the criteria for Named Selections based on geometric or meshing entities. Each row of the worksheet performs a calculation for the specified criteria. If multiple rows are defined, the calculations are evaluated and completed in descending order.
To define named selections using Worksheet criteria:
Highlight the Selection object. In the Details view, set Scoping Method to Worksheet.
As needed, right-click the mouse and select .
Enter data in the worksheet for specifying the criteria that will define a Named Selection. See the Worksheet Entries and Operation section below for specific entry information.
Click the button located on the Worksheet to create the Named Selection based on the specified criteria. Alternatively, you can right-click the Named Selection object and choose Generate Named Selection from the context menu.
If you change the Scoping Method from Geometry Selection to Worksheet, the original geometry scoping will remain until you select Generate.
When you select Generate and the generation fails to produce a valid selection, any prior scoping is removed from the Named Selection.
If there is no indication that the worksheet has been changed and the Named Selection should be regenerated, you still may want to select Generate to ensure that the item is valid.
If a row inside the worksheet has no effect on the selection, there are no indications related to this.
Named Selections require valid scoping. If the application detects a criterion that is not properly scoped, it becomes highlighted in yellow to alert users of a possible problem. A highlighted criterion does not effect on the overall state of the object.
Named Selections created using the Worksheet may not support virtual entities.
A sample worksheet is illustrated below. Criteria of the Worksheet is defined by making selections in the drop-down menus of the columns for each row. Certain values are read-only or they are only available as the result of other criterion being specified.

As illustrated here, when you add a row into the Worksheet, additional right-click context menu options become available. When using these options, you need to also click the button to have these changes applied to the Named Selection.

The content of each Worksheet column is described below.
Action column:
: Adds the information defined in the current row to information in the previous row, provided the item defined in the Entity Type column is the same for both rows.
: Removes the information defined in the current row from information in the previous row, provided the geometry defined in the Entity Type column is the same for both rows.
: Establishes a subset of the information defined in the previous row.
: Selects all items of the same Entity Type that are not currently in the named selection.
: Changes the geometric Entity Type selected in the previous row. The change is in either direction with respect to the topology (for example, vertices can be converted "up" to edges, or bodies can be converted “down” to faces). When going up in dimensionality, the higher level topology is selected if you select any of the lower level topology (for example, a face will be selected if any of its edges are selected). You can also convert from a geometry selection (bodies, edges, faces, vertices) to mesh nodes. The nodes that exist on the geometry (that is, the nodes on a face/edge/vertex or nodes on and within a body) will be selected. In addition, node-based Named Selections can be converted to elements and element-based Named Selections can be converted to nodes using this action.
The Entity Type column:
: this option is used when the Action column is set to in order to convert either a face-based named Selection or a node-based Named Selection to a new Element Face Named Selection. Note that this option does not support element faces that share two (or more) bodies or element faces defined on shell bodies.
Criterion column:
- available when Entity Type = , , or .
- available when Entity Type = , , , or , or .
- available when Entity Type = .
- available when Entity Type = or . Applies to faces that are cylindrical and edges that are circular.
Distance
Note: For the Distance Criterion, the calculation of the centroid is not supported for Line Bodies.
- available when Entity Type = , , . This option is useful when you want to create a Named Selection of faces, edges, or vertices shared across bodies.
- available when Entity Type = . This option is useful for examining and working with shared nodes that were generated by Node Merge or Mesh Connection operations.
- available when Action = and Entity Type = . This option requires a Value entry. The Value entry defines the number of elements to which a node is connected. For example, if you enter a Value of , the application selects every node in the model that is connected to four elements.
This option supports 2D and 3D analyses for all element types.
- available when Entity Type = .
- available when Entity Type = .
- available when Entity Type = . This option is supported for surface/shell bodies only.
- available when Entity Type = .
- available when Entity Type is .
- available when:
Action =
Entity Type = or (node-based conversion only)
- available when:
Action =
Entity Type = or (node-based conversion only)
For Entity Type = .
You may wish to refer to the Mesh Metric section of the Meshing User's Guide for more information about these Criterion options.
Operator column:
- available when Criterion = .
includes Lower Bound and Upper Bound numerical values that you enter.
- only available when Action column =
- only available when Action column =
Note: The and options apply to the entire model. They do not function with any other worksheet criteria entry. Therefore, they are only available when the Action column is set to .
Units column: read-only display of the current units for Criterion = or .
Value column:
For Criterion = , enter positive numerical value.
For Criterion = or , enter numerical value.
Note: Selection location is at the centroids of edges, faces, bodies, and elements.
For Entity Type = and Criterion = :
For Entity Type = and Criterion = : select the desired cross section name from the drop-down list.
For Entity Type = and Criterion = :
For Entity Type = Criterion = :
For Entity Type = and Criterion = :
For Entity Type = and Criterion = , enter a valid body name. When:
Operator = , you can enter a partial body name. The application matches name characters at the beginning, middle, or at the end of the name.
Operator = , you must enter the body name exactly as it appears in the Geometry folder.
Operator = , you enter the body name that you do not wish to include in your named selection. The application will select all other bodies from the Geometry folder.
For Entity Type = and Criterion = :
For Entity Type = and Criterion = , enter the number of shared edge connections. For example, enter Value = 0 for edges not shared by any faces, enter Value = 1 for edges shared by one face, and so on.
For Criterion = , you can include a previously-defined named selection from the Value field. Only the named selections that appear in the tree before the current named selection are listed in Value. For example, if you have defined two named selections prior to the current named selection and two named selections after, only the two prior to the current named selection are shown under Value.
When you define a named selection to include an existing named selection, you should use the RMB option from the Named Selections folder object in the tree to make sure that all of the latest changes to all named selections are captured. Named selections are generated in the order that they are listed in the tree and as a result, when you click the button in the Worksheet, only the associated named selection is updated. Any other Named Selection that may have been changed is not updated. The feature better ensures that all child objects of the Named Selection folder are updated.
For Criterion = , you can include a previously-defined named selection in the Value field. You can select from the named selections provided in the list only.
For Criterion = , select the desired material from the drop-down list. See the Material Assignment topic for more information.
For Criterion = Distance, enter a positive numerical value from the origin of the selected coordinate system.
For Criterion = , enter a positive numerical value or values based on the selection made in the Operator column.
Lower Bound column: enter numerical value.
Upper Bound column: enter numerical value.
Coordinate System column:
Global Coordinate System
Any defined local coordinate systems
Tolerance settings are used when the Operator criterion is defined as an "equal" comparison. Tolerances are not used when doing greater than or less than operations. Tolerance values apply to the entire worksheet. If you wish to adjust the tolerance settings for worksheet criteria, use the Tolerance settings in the chosen Named Selection’s Details view.
By default, the Zero Tolerance property is set to 1.e-008 and the Relative Tolerance value is 1.e-003. As a result of the significant digit display, the value used for calculations and the display value may appear to be different. The Zero Tolerance property’s value is past the number of significant digits that Mechanical shows by default. The application’s default setting for significant digits is 5 (the range is 3 to 10). This setting affects only the numbers that are displayed, any calculation or comparison uses the actual values when processing. In addition, it is important to note that most values (including selection values seen in the status bar and the Selection Information window) in Mechanical display in a significant digit format. See the Appearance option in the Setting ANSYS Workbench section of the Help for information about changing default display settings.
Setting the tolerance values manually can also be useful in meshing, when small variances are present in node locations and the default relative tolerance of .001 (.1%) can be either too small (not enough nodes selected) or too big (too many nodes selected).
In the Details view, set Tolerance Type to .
Specify either a Zero Tolerance or a Relative Tolerance. Tolerance values are dimensionless. Relative tolerance is a multiplying factor applied to the specified worksheet value. For example, if you want a tolerance of 1%, enter .01 in the Relative Tolerance field.
All comparisons are done in the CAD unit system. If your current unit system is not the same as the CAD unit system, the values entered will first be converted to the CAD unit system before searching for criteria.