Cell text disappearing when freezing the cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2029182%22%20slang%3D%22en-US%22%3ECell%20text%20disappearing%20when%20freezing%20the%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029182%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20hoping%20someone%20can%20help%20as%20I%20cannot%20seem%20to%20find%20any%20similar%20situations.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20Excel%20for%20Mac%202016.%20I've%20created%20a%20spreadsheet%20that%20has%20my%20headings%20in%20row%201.%20A%20selection%20of%20them%20are%20formatted%20at%20an%20alignment%20orientation%20of%2045%20degrees%20(%20seen%20in%20the%20screen%20grab%20'%20Screen%201').%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20freeze%20this%20top%20row.%20(%20I%20usually%20have%20no%20issue%20working%20with%20freezing%20panes%20etc.)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20select%20to%20either%20freeze%20a%20selection%20of%20cells%2C%20first%20row%20or%20first%20column%2C%20the%20text%20in%20the%2045%20degree%20orientated%20cells%20disappears!%20You%20cannot%20view%20it%20(%20As%20you%20seen%20in%20'screen%202'%20)%20but%20can%20view%20the%20heading%20text%20that%20is%20not%20oriented%20at%20this%20angle.%20However%2C%20if%20you%20click%20on%20the%20cell%20the%20original%20title%20will%20still%20show%20on%20the%20formula%20bar.%20Help!%20I%20would%20like%20all%20of%20these%20headings%20to%20be%20oriented%2C%20but%20show%20when%20I%20freeze%20the%20row%20(%20for%20obvious%20reasons%20being%20able%20to%20scroll%20down%20across%20multiple%20rows%20and%20still%20know%20which%20column%20I%20am%20on).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20lock%20and%20unlock%20the%20cells%2C%20I%20have%20also%20tried%20various%20other%20cell%20formating%20such%20as%20Text%20%2F%20General%20%2F%20Custom.%20Nothing%20seems%20to%20make%20these%20cells%20show%20their%20headings%20when%20frozen.%20If%20the%20cells%20are%20oriented%20to%2090%20degrees%20they%20do%20show.%20So%20at%200%20and%2090%20degrees%20they%20show%2C%20but%20anything%20in%20between%20they%20don't.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20fix%20for%20this%3F%20Thank%20you%20so%20much!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2029182%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi everyone, 

I'm hoping someone can help as I cannot seem to find any similar situations. 

 

I'm using Excel for Mac 2016. I've created a spreadsheet that has my headings in row 1. A selection of them are formatted at an alignment orientation of 45 degrees ( seen in the screen grab ' Screen 1'). 

I want to freeze this top row. ( I usually have no issue working with freezing panes etc.) 

 

When I select to either freeze a selection of cells, first row or first column, the text in the 45 degree orientated cells disappears! You cannot view it ( As you seen in 'screen 2' ) but can view the heading text that is not oriented at this angle. However, if you click on the cell the original title will still show on the formula bar. Help! I would like all of these headings to be oriented, but show when I freeze the row ( for obvious reasons being able to scroll down across multiple rows and still know which column I am on).

 

I have tried to lock and unlock the cells, I have also tried various other cell formating such as Text / General / Custom. Nothing seems to make these cells show their headings when frozen. If the cells are oriented to 90 degrees they do show. So at 0 and 90 degrees they show, but anything in between they don't. 

 

Is there a fix for this? Thank you so much! 

0 Replies