Wrap text and vertical alignment issues

Since I uninstalled 2016 and reinstalled 2013 as 2016 was not compatible with graphic software I am using I am having formatting problems with an excel tables which use vertical alignment. Basically it appears that wrap text is not now working and vertical alignment does not recognise the height of the cells and wont auto fit – I am trying to top and centre justify and apply wrap text - see attached

Can anyone help

maybe use autofit for rows and columns

is that what you want?

Hi Sandy
Ive tried autofit both with columns and rows but has no effect, did you try it on the attachment I sent?
David

you didn't answer about my Q from post#4

Hi Sandy
No its the header row on row 2 which is the problem when using vertical alignment and / or wrap text
David

Hi Davo
No - as you can see the header row text ( row 2) is only partially in the cell - this is the problem usually vertical alignment and wrap texct you can top and center justify

David

Hi Sandy

The image you sent is what I want to achieve - but the attached is what I get - as you can see the text runs outside of the cell and wrap text doesnt work
dave

but I sent two pictures so which one is ok for you?

Originally Posted by sandy666

but I sent two pictures so which one is ok for you?

The first one please

ab ovo

1. headers are horizontal
2. set them to vertical
3. change height of headers row manually to value what you need
4. select all headers in table
5. use wrap
6 use autofit

hope it will work for you

Thanks for your help Sandy, unfortunately it doesnt work, still having the same problem, Im used to working with these features - the problem has only arisen since moving from 2016 to 2013 so can only assume its a bug or poor installation