Link to home
Start Free TrialLog in
Avatar of fasse
fasse

asked on

Text in excel wrapping or flowing to next column

PartDescription
FTG 6400-8-6/S-MJ-MO
FTG 6408-8/MO HHP

I have the above text in a spreadsheet.  I want to be able to narrow the column and have the text that can't be displayed just disappear.  I don't want it to wrap and create a taller row, or over flow to the next column I just want it to hide it and make it shorter.  Is this possible.

Thanks
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

You will have to put something in the adjacent cell even if it's just an apostrophe (which will not appear in the cell)
Actually, I take that back. Format the cell (Ctrl+1) and on the alignment tab change the horizontal alignment to Fill.
PS That will however repeat your text if you make the cell wide enough, so you may want to stick to the apostrophe!
ASKER CERTIFIED SOLUTION
Avatar of Magadu
Magadu
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
P.S This works even id the adjacent cells are blank.