Cell alignment

I can't find how do achieve the alignment that I want.

I have a block of cells in one column. The cells are filled with text.

I want the block to be left aligned. That is easy.

But I want the block as a whole to be right aligned.


Where the cells are left aligned with each other but the block as a whole is right aligned.

Sorry I cannot get the font to work to show what I want.

Hi, is what you're talking about centering the contents per column? If so, select a column/s, right click and click the three lines beside the cell fill. Should say "center" when highlighted.

indent.png

I want to achieve this effect.

The longest string is right aligned and the other strings are left aligned with the longest string.

I achieved my example using left align and indent but I want the effect to be automatic if the cells values change or the cell width is changed.