Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a sheet that contains a column of xpath expressions (these resemble file paths.) For the most part the first 50 or so characters are always the same. This causes the data to be unhelpful when the column width is made too narrow. Is there a way to get Excel to only show the latter portion of the record when the column is shrunk down.

The actual data looks like this but is quite a bit wider: (and can't change)


When the column is narrow I see this:


I want to see something like this:

share|improve this question
Setting the cell to justify to the right? – Michael Kjörling Mar 27 '13 at 14:57
up vote 7 down vote accepted

The start of the text is displayed by default because the text is aligned to the left (start) of each column. Set the column's alignment to Align Text Right and it will show the ending of each cell when the data is cut off.

share|improve this answer
Doh! I should have tried that. Thanks! – Chris Nava Mar 27 '13 at 15:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.