Gotta be an easy formatting issue

aemiller2112 · Apr 2nd, 2002, 08:55 AM

I have cells that have data that is too long to view all at once. I don't want this data to run over the next blank cell. Is there a formatting setting that will prevent this from happening. I just want the see what is visible until it reaches the next cell over, then I want the text to stop being visible.

d-alan · Apr 2nd, 2002, 09:08 AM

If you goto:
format>cells>alignment and check shrink to fit, it will keep all the info in that cell.
It will however, if there is a lot of info shrink the info so small that you will not be able to read it in the cell alone. You will have to select the cell to see the info.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 08:55 AM	#1
aemiller2112 New Member Join Date: Apr 2002 Posts: 1	I have cells that have data that is too long to view all at once. I don't want this data to run over the next blank cell. Is there a formatting setting that will prevent this from happening. I just want the see what is visible until it reaches the next cell over, then I want the text to stop being visible.

Apr 2nd, 2002, 09:08 AM	#2
d-alan Board Regular Join Date: Mar 2002 Posts: 119	If you goto: format>cells>alignment and check shrink to fit, it will keep all the info in that cell. It will however, if there is a lot of info shrink the info so small that you will not be able to read it in the cell alone. You will have to select the cell to see the info.