Share via

Wrap Text Has Suddenly Stopped Working In Excel

Anonymous
2021-08-04T22:57:00+00:00

I'm doing a research project where I'm collecting information about research done using ontologies on the Covid-19 Pandemic. I have a spreadsheet I'm using to collect info about various papers and projects. For some reason Wrap Text seems to have stopped working in new cells, or at least some of them. Check cell 22A. The formatting for the whole column is Wrap Text. The text is "Managing COVID-19 Crisis using C3HIS Ontology" but rather than wrap all I see displayed is the last part of the text left justified: "C3HIS Ontology" . Also, check cells 21-22K. The text is: "Description Logic.. further doubt or thought." I left out a lot because it is very long but again all that shows up is some text, this time from the middle with no wrapping. I thought it might be something weird about that row so I copied and pasted into the rows below but same behavior. I also thought it might be something weird about the specific text so I copied from cell K20 (which wraps correctly) to cell K23 and got the same behavior. I don't see a way to attach a file so I put it on Google drive and created a public link: https://drive.google.com/file/d/1oVeAsPo7NYzu59psq-7F8dV1AZ553jKP/view?usp=sharing 

Also, I noticed in the Google drive preview it looks correct but I tried downloading the file and then opening it in Excel and it still has the problem.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2021-08-04T23:35:11+00:00

    Hi

    My name is Eduardo. I am an independent consultant, first of all thanks for being part of the Microsoft Community, I will try to help you.

    I downloaded your file and saw your issue, you can take a look in this article from microsoft who explai how to autofill the row height. Your file need to auto adjust teh height of the line, when you left the wrap text the text goes right.

    https://support.microsoft.com/en-us/office/wrap...

    I hope this information is useful for you. If you still have questions, answer here so I can continue helping you.

    Sincerely,

    Eduardo

    1 person found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-08-05T00:32:10+00:00

    You guys are awesome. I tried Eduardo's suggestion and that worked. Thanks for all the quick and helpful info.

    0 comments
  2. Anonymous
    2021-08-04T23:48:39+00:00

    Re: some thoughts...

    1. An improvement to scrolling in Excel appears to be ready for release, see...

    https://answers.microsoft.com/en-us/msoffice/forum/all/office-for-windows-beta-release-notes-july-30-2021/11e438e3-213f-42cd-a40c-3ac50c1bd63d

    "You’re now able to stop scrolling partially through a row or column, and Excel will not force the sheet to snap to the edges."

    1. It is good practice to "clean" imported data before using it in Excel.

    . See the "Clean Data" option in the free 'Professional Compare' workbook...

    https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

    1. As Shane D. advised, resizing the row height is necessary.

    . You may find that a final manual adjustment to the row height (in some rows) may

    . still be necessary.

    '---

    NLtL

    0 comments
  3. Anonymous
    2021-08-04T23:23:53+00:00

    Try best-fitting the rows. The Wrap Text will work but it will wrap based on column K which has a "lot" more text.

    0 comments