D
DocBrown
Can someone tell me the 'rules' that Excel is using in this situation? And an
impossible question: why?
I have a table that has a header row with AutoFilters turned on. If I select
the row following the header and select Right-click insert. A row is inserted
above the current one, but the row inherits the formatting and other
attributes from the row above.
Why the heck is it inheriting from the row above but inserting above the
selected row. I would more expect the inserted row to inherit from the
selected row.
Second question. Most columns are not inheriting the borders, but three
columns are. What would cause some columns to inherit the borders but not
others?
Thanks a bunch,
John S.
impossible question: why?
I have a table that has a header row with AutoFilters turned on. If I select
the row following the header and select Right-click insert. A row is inserted
above the current one, but the row inherits the formatting and other
attributes from the row above.
Why the heck is it inheriting from the row above but inserting above the
selected row. I would more expect the inserted row to inherit from the
selected row.
Second question. Most columns are not inheriting the borders, but three
columns are. What would cause some columns to inherit the borders but not
others?
Thanks a bunch,
John S.