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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
P.S This works even id the adjacent cells are blank.