Headings Row 1 Text alignment

[AlexanderBB]

Width is set to 45 and col names are centered.
Somehow I've managed another effect which I can't repeat. The names are vertically aligned so they're about 1/16
of an inch above the bottom of the cell. Not bottom, centered, or any other setting offered by the Alignment tab (Format Cells).
Any idea how I might have done this ? Thanks.

 

[Rick Rothstein]

Width is set to 45 and col names are centered.
Somehow I've managed another effect which I can't repeat. The names are vertically aligned so they're about 1/16
of an inch above the bottom of the cell. Not bottom, centered, or any other setting offered by the Alignment tab (Format Cells).
Any idea how I might have done this ? Thanks.

Strange you should be asking us to explain how you did something. Anyway, one way I can think of is to end your text with a Line Feed followed by a space character and then select that space character and change its Font Size to some appropriately small number.

 

[AlexanderBB]

It would have been a few years ago and I can't remember what I did. And I didn't know anything back then.
I tried your suggestion but the Arial Narrow font size is already 10. The LF/Space almost centers it. (Higher than the original)
It's not a major, just puzzling.. can't format paint it to another column either.

 

[Rick Rothstein]

It would have been a few years ago and I can't remember what I did. And I didn't know anything back then.
I tried your suggestion but the Arial Narrow font size is already 10.

I was not implying you change the entire cell's font size, rather, just the font size of the trailing space located on the second line. You do that by selecting that single character and changing its font property (in this case, the font size). Also note that for this to work, you would have to turn Wrap Text on for the cell.

 

[AlexanderBB]

Kind of have a result, it still a lot higher though. But I don't think the original (unknown) method was that. There's no LF or space and you can use the name without needing trim or anything.
A small screen shot would show you and I'm looking at your link for that

 

[Rick Rothstein]

Kind of have a result, it still a lot higher though. But I don't think the original (unknown) method was that. There's no LF or space and you can use the name without needing trim or anything.
A small screen shot would show you and I'm looking at your link for that

Better than a small screen shot would be a copy of the actual file so that we can look at the cell and its properties directly, otherwise all we will be able to so here is take wild guesses. If you are able, post a copy of the workbook to DropBox and post a shared link back here.