In general, the rows in a linked subset behave the same as their corresponding rows in the original table. If you select rows in the original table, any rows included in the subset are also selected. Likewise, if you select rows in the subset, the corresponding rows are selected in the original table. If you change cell values in the original table, the same cells in the subset table also change. If you change a cell value in the subset, the corresponding cell changes in the original table.
Columns behave differently than rows.
Selected columns do not automatically become selected to and from the original and subset tables. However, you can select a column in either table and use its Column Info dialog to change column characteristics. The characteristics of the same column in the other table change to match. This action automatically produces a linked subset of the selected rows and columns. If there are any columns with formulas in the original table and you uncheck the Link to original data table check box, the formula check boxes become active.