One of my main uses for a spreadsheet package is to produce family trees. What I’ve done for years now in Excel is to set out the details of individuals in cells – so for example a vertically contiguous group might hold forename, surname, date of birth, place of birth, date of death, place of death for a given person, with comments attached to the cells holding details of the sources of each fact. I then draw vertical and horizontal lines connecting family members, their parents / children and so on, using the drawing tools.
So I’ve now got lots of sheets originally produced via Excel 2003 with lines that I would like to ensure are anchored and resized. Is there a way to apply this attribute to all existing lines in a sheet as a group, and is there a way to make this the default for new sheets as well?
