Excel Auto-Fit of Rows and Columns

M

Maria

I am using auto-fit for the heights of the columns but for some reason it
does cover up parts of the content. Also for the width some sentences do
cross the right border.
I tried to put the spreadsheet into a new document and also tried to copy
cell by cell into a band new document, but for some reason the same issue
keeps coming up.
I would be very thankful if someone could help me with that problem.
Maria
 
V

Vergel Adriano

Maria,

Text will cross over to the right if the "Wrap Text" option is not set.
Format->Cells, in the Alignment tab, make sure "Wrap Text" is checked.

Auto-fit for row heights will not work if there are merged cells in the row.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top