Filter, sort and customize node matrices

 

 

Filter, sort and customize node matrices


What do you want to do?


 


Filter columns or rows

Using filters, you can show or hide columns or rows based on the values displayed in the node matrix—for example, Apply a filter to Column A to hide rows where there are no coding references for small businesses.

To filter a column:

  1. Select the column.

  2. On the Layout tab, in the Sort & Filter group, click Filter, and then click Filter Column.

rn_layout_sortfilter.gif

The Node Matrix Filter Options dialog box opens.

  1. Specify the filter you want to apply—refer to Applying filters for more information.

  2. Click OK. The filter icon ui_filter_red.gif at the top of the column displays red to indicate a filter has been applied.

NOTE

ic_top_of_page.gifTop of Page

Sort by column

  1. Select a column that you want to sort on.

  2. On the Layout tab, in the Sort & Filter group, click Sort By and then click Column.

rn_layout_sortfilter.gif

The data is sorted by the selected column in ascending order.

NOTE  You can repeat the steps above to sort the selected column in descending order.

ic_top_of_page.gifTop of Page

You can rearrange the columns and rows in a node matrix—this can be useful if the matrix is too wide to display in Detail View.

  1. Click in the node matrix in Detail View.

  2. On the Layout tab, in the Rows & Columns group, click Transpose.

rn_layout_rowscolums_transpose.gif

The columns and rows are rearranged.

ic_top_of_page.gifTop of Page

Hide rows or columns

  1. Click the row or column header to select the row or column.

  2. On the Layout tab, in the Show/Hide group, click rn_layout_showhide_hiderow.gif Hide Row or rn_layout_showhide_hidecolumn.gif Hide Column.

The selected row or column is hidden.

ic_top_of_page.gifTop of Page

Show hidden rows or columns

To show all hidden rows or columns:

All hidden rows or columns become visible.

To show a single hidden row or column:

  1. Do one of the following

  1. On the Layout tab, in the Show/Hide group, click rn_layout_showhide_unhiderow.gif Unhide Row or rn_layout_showhide_unhidecolumn.gif Unhide Column.

The hidden row or column becomes visible.

ic_top_of_page.gifTop of Page

Adjust column width

cn_resizing_columns.gif

ic_top_of_page.gifTop of Page