Google Sheets text rotated up, how to clip text end instead of beginning?

Question

I have a very large table where the columns and rows are named, and interior cells are "1" or empty (essentially a sparse matrix). I have rotated the column header text direction up so that the columns may be narrow. Here is a simplified example:

Some column names are very long, so the cells cannot be the entire height of the column names. When I resize the column name row to be smaller height, the text is clipped in the wrong direction. Prefixes of the names are incorrectly cut off instead of suffixes as desired. See cell B1 in simplified example of the problem:

How can I change the direction that text clipping occurs?

Answer 1

You have a long header cell that you have rotated to save space. However, when the height of the row is shortened, a "long" value is effectively right-aligned so that the end of the value is shown rather than the beginning.

As noted by @marikamitsos, it's not possible to do what you wish.

However, wrapping the text is a good work-around to display the entire cell while keeping a relatively narrow column width.

---

Answer 2

For now, I have worked around the issue by rotating the text down instead of up. Although this doesn't achieve the alignment aesthetic I wanted, it will suffice for now, and clipping end of value text works properly.