using Excel to make a family tree

[StR]

Hello,

I am using Excel to make an extended family tree and have set the column width at 1.71 to allow greater control and flexibility over placing boxes and connector lines.

Since I have a large family the tree is VERY wide, and I've maxxed out on the number of allowable columns.

If I could shift it to run vertically instead of horizontally, this would help, but would necessitate prolonged work on a spreadsheet with sideways content.

Is it possible to do this, but view it normally -- or some similar solution?

Thanks.

P.S. I've tried Excel templates for family trees, but they're designed for very simple trees and don't work for my purposes.

 

[nbrcrunch]

StR: Welcome to the MrExcel board. You've had 20 views of your post as of my writing.

Excel is not the right tool for the task. You've already begun to realize that. Though it seems you've already spent considerable time in this effort, the further you go the more frustrated you'll get. It would be much easier to cut your losses now and invest in something that was designed for your needs.

Amazon has a number of products ranging from $25 to $85
https://www.amazon.com/s/ref=nb_ss_...ces&sprefix=ances&sprefix=ances&sprefix=ances

 

[StR]

Thank you for the quick response.