If anyone can assist, I'd be most grateful.
Firstly, Extend Formats & Formulas to Additional Rows is checked in Oprions
under the Tools menu.
BUT, as well as extending formats & formulas (which is really useful and I
want to keep this facility), links to info sources from the row below are
also collected and implanted into the newly inserted row (I use the Insert
drop down menu), which isn't useful and will cause major problems with
spreadsheet results. Is there a different box which needs to be checked or
some other measure which will sort thisout for me?