EXCEL - text alignment - TechRepublic
Question
October 9, 2013 at 06:34 AM
blankbit

EXCEL – text alignment

by blankbit . Updated 12 years, 7 months ago

So short of using a space or ‘ to force a cell to clip the visible text when it is left justified (makes cmd/cntrl A not as useful), is there a way to stop Format Cell > Alignment FILL from replicating shorter length values to “fill” the cell. My file has a list of values in the last cell, some very long, some single value. “Fill” is replicating the short lists over and over, which is not what I need for this file.

I just want to clip visible text, not replicate shorter values until it “fills” the space. Or I guess, is there another way to achieve visual clipping of the values in a cell without wrapping or using spaces/’?

This discussion is locked

All Comments