P
Paul Williams
I have an excel spreadsheet of 279 rows: a 4-row header
and 25 sets of 11 rows each. Row heights within each set
have been set individually, though the pattern is common
to each set.
When the 275 non-header rows are sorted as a group, the
row heights of most, but not all, of the final 2 rows of
each set are changed. The heights of the first 9 rows of
each set are not changed.
The final row of each set is empty except for one cell.
The cell in the selected sort column is empty. The one
non-empty cell contains numeric data in another sort key
column. Row 11 formatting consists of a color and
borders.
The next to final row of each set has content in a second
column. In the first set of rows, the cell contains a
text label; in all other sets, the cell contains a
reference to the cell in the first set. Row 10
formatting includes different borders but no color.
The selected sort column contains the word "Data" in rows
1:4 and 8 of each set, and nothing in the other rows. A
second sort key column, the one containing the numeric
data, contains the row numbers, 1 to 279.
I tried changing the cell references on row 10 of sets
2:10 from absolute ($) to relative. The height of just
one row changed, row 279 (row 11 of set 25). None others
changed.
Has anyone encountered this problem? I am particulary
struck by the resetting to the previous row height, and
what it is that might trigger that, and more importantly
prevent it.
and 25 sets of 11 rows each. Row heights within each set
have been set individually, though the pattern is common
to each set.
When the 275 non-header rows are sorted as a group, the
row heights of most, but not all, of the final 2 rows of
each set are changed. The heights of the first 9 rows of
each set are not changed.
The final row of each set is empty except for one cell.
The cell in the selected sort column is empty. The one
non-empty cell contains numeric data in another sort key
column. Row 11 formatting consists of a color and
borders.
The next to final row of each set has content in a second
column. In the first set of rows, the cell contains a
text label; in all other sets, the cell contains a
reference to the cell in the first set. Row 10
formatting includes different borders but no color.
The selected sort column contains the word "Data" in rows
1:4 and 8 of each set, and nothing in the other rows. A
second sort key column, the one containing the numeric
data, contains the row numbers, 1 to 279.
I tried changing the cell references on row 10 of sets
2:10 from absolute ($) to relative. The height of just
one row changed, row 279 (row 11 of set 25). None others
changed.
Has anyone encountered this problem? I am particulary
struck by the resetting to the previous row height, and
what it is that might trigger that, and more importantly
prevent it.