table in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2281390%22%20slang%3D%22en-US%22%3Etable%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281390%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20create%20a%20family%20tree%20in%20Excel%20-%20I%20need%20several%20lines%20of%20text%20in%20each%20cell.%26nbsp%3B%20However%20big%20I%20make%20the%20cell%2C%20I%20still%20only%20get%20one%20line%20of%20text%20at%20the%20bottom%20of%20the%20cell.%26nbsp%3B%20What%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2281390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282433%22%20slang%3D%22en-US%22%3ERe%3A%20table%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282433%22%20slang%3D%22en-US%22%3EOh%20thank%20you%20very%20much%20-%20I%20will%20have%20another%20go.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2282316%22%20slang%3D%22en-US%22%3ERe%3A%20table%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282316%22%20slang%3D%22en-US%22%3EWhat%20I%20have%20sent%20you%20is%20intended%20as%20a%20template.%20Expand%20it%20as%20you%20wish%20by%20simply%20inserting%20columns%2C%20starting%20with%20column%20A.%3CBR%20%2F%3EIt%20is%20very%20difficult%20for%20me%20to%20imagine%20that%20you%20will%20find%20exactly%20one%20where%20all%20your%20ancestors%20could%20fit.%20It%20is%20even%20more%20difficult%20to%20imagine%20that%20someone%20takes%20the%20time%20or%20has%20the%20time%20to%20prepare%20a%20template%20for%20your%20family%20without%20seeing%20it%20as%20commissioned%20work.%20But%20you%20never%20know%2C%20you%20can%20let%20it%20happen%2C%20maybe%20someone%20will%20get%20in%20touch%20...%20or%20you%20can%20start%20with%20the%20template%20to%20do%20it%20yourself.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281905%22%20slang%3D%22en-US%22%3ERe%3A%20table%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281905%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20this%3B%20I%20looked%20at%20this%20before%20but%20it%20does%20not%20have%20enough%20generations%20for%20me%2C%20like%20all%20the%20others%20I%20have%20looked%20at.%26nbsp%3B%20I%20need%20something%20which%20would%20cater%20for%20up%20to%2014%20greats%2C%20ie%20back%20to%201500%2C%20which%20is%20why%20I%20am%20trying%20to%20create%20my%20own.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281797%22%20slang%3D%22en-US%22%3ERe%3A%20table%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281797%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1033670%22%20target%3D%22_blank%22%3E%40Cres_cent-1331%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-1304038928%22%20id%3D%22toc-hId-1304133979%22%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2Ffamily-tree-chart-tm01021967%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EFamily%20tree%20chart%3C%2FA%3E%3C%2FH1%3E%3CP%3ETrace%20your%20genealogy%20using%20this%20handy%20family%20tree%20chart.%20This%20template%20covers%20five%20generations%20of%20relatives%20and%20has%20space%20for%20each%20family%20member's%20name%20and%20title.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281405%22%20slang%3D%22en-US%22%3ERe%3A%20table%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281405%22%20slang%3D%22en-US%22%3EMany%20thanks.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2281403%22%20slang%3D%22en-US%22%3ERe%3A%20table%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281403%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1033670%22%20target%3D%22_blank%22%3E%40Cres_cent-1331%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20the%20cell%20or%20cells.%3C%2FP%3E%0A%3CP%3EMake%20sure%20that%20the%20Wrap%20Text%20button%20in%20the%20Alignment%20group%20of%20the%20Home%20tab%20of%20the%20ribbon%20is%20on%20(highlighted).%3C%2FP%3E%0A%3CP%3ETo%20enter%20a%20line%20break%20in%20a%20cell%2C%20press%20Alt%2BEnter.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Trying to create a family tree in Excel - I need several lines of text in each cell.  However big I make the cell, I still only get one line of text at the bottom of the cell.  What am I doing wrong?

 

6 Replies

@Cres_cent-1331 

Select the cell or cells.

Make sure that the Wrap Text button in the Alignment group of the Home tab of the ribbon is on (highlighted).

To enter a line break in a cell, press Alt+Enter.

Many thanks.

@Cres_cent-1331 

Family tree chart

Trace your genealogy using this handy family tree chart. This template covers five generations of relatives and has space for each family member's name and title.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

@NikolinoDE 

Thanks for this; I looked at this before but it does not have enough generations for me, like all the others I have looked at.  I need something which would cater for up to 14 greats, ie back to 1500, which is why I am trying to create my own.

What I have sent you is intended as a template. Expand it as you wish by simply inserting columns, starting with column A.
It is very difficult for me to imagine that you will find exactly one where all your ancestors could fit. It is even more difficult to imagine that someone takes the time or has the time to prepare a template for your family without seeing it as commissioned work. But you never know, you can let it happen, maybe someone will get in touch ... or you can start with the template to do it yourself.

Thank you for your understanding and patience


Nikolino
I know I don't know anything (Socrates)
Oh thank you very much - I will have another go.