I am experiencing two issues when inserting rows in Excel 2003:
1. Subtotals
When I have a row comprising subtotals of the rows above, and insert a row directly above it, the subtotals do not expand to include the new row. Is there a way automatically to include the new row in the subtotal in these circumstances ?
If I insert the new row between two rows which are included in the subtotal, then the subtotal does expand to include the new row
2. Copying formulae
This is just a minor annoyance – when I insert a row, as above, sometimes formulae in the row above the inserton are copied to the new row, sometimes not. I cannot see any rhyme or reason for which are and which aren’t – and, as its inconsistent, I have to check them all. What’s going on here ?
Thanks
Martin