Apply To:
Microsoft Excel 2010
Problem:
Could not see the content or text or data in Column of Microsoft Excel,
and display character "#####"
Example, filename : "Sample Shrink To Fit and Wrap Text.xls"
Link: https://docs.google.com/file/d/0B6a5vK3IVP_0ZkYtdEtISlgxem8/edit?usp=sharing
Solution:
1. Open the Example file
2. Block all of Column "B"
3. Right-click and choose "Format Cells..."
4. Choose Tab "Alignment"
5. Un-tick for Text Control = Wrap Text
6. Tick for Text Control = Shrink To Fit
7. Tick again for Text Control = Wrap Text
8. Then Click OK. Will display an content of column.
9. And example of results file in filename "Results Shrink To Fit and Wrap Text.xls"
Link: https://docs.google.com/file/d/0B6a5vK3IVP_0cEdKWFViRHBNcEk/edit?usp=sharing