Question

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation.
Harold cannot increase the width of his worksheet because, if he does, he will not be able to print it on one sheet. However, his columns are truncating his content. What solution would be the best for Harold to use to make all his text visible without losing data?
a) abbreviate all text
b) change the font style
c) choose Wrap text for the columns
d) delete one column

Answer 1

Answer:

Harold should go with the option C. Wrap text for the columns

Explanation:

Wrapping text in a column helps to avoid reasons to truncate columns. It helps to display the contents of a cell in multiple lines instead of just one line.

This makes the text inserted easily readable and printable.

Harold's best choice is to choose Wrap text for the columns. To do this:

1. Select the affected cells.
2. Click on the home tab
3. Locate the Alignment section
4. And click the Wrap text icon.