Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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)

/some/path/to/my/stuff/name
/some/path/to/my/stuff/address
/some/path/to/my/stuff/city
/some/path/to/my/stuff/state
/some/path/to/my/stuff/zip

When the column is narrow I see this:

/some/path/to
/some/path/to
/some/path/to
/some/path/to
/some/path/to

I want to see something like this:

...ff/name
...ff/address
...ff/city
...ff/state
...ff/zip
share|improve this question
4  
Setting the cell to justify to the right? –  Michael Kjörling Mar 27 '13 at 14:57

1 Answer 1

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

 
discard

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.