+ Reply to Thread
Results 1 to 3 of 3

Word wrap problem with .xls output of Google Docs

  1. #1
    Registered User
    Join Date
    04-01-2010
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Word wrap problem with .xls output of Google Docs

    A discussion about sharing ideas for startup businesses:

    Developing new startup ideas

    led to this shared Google spreadsheet:

    startup ideas spreadsheet

    While I am no whiz at Excel, I wanted to manipulate the items on my desktop with Excel 2007, so I downloaded the Excel version of the file (File/Download as Excel). When I load the Excel .xls format into Excel 2007, it opens fine, but the word wrap is inconsistent. Some rows have the words wrapped, and some don't. When I click between the 1 and A to select the entire sheet, and click on "Word wrap" to toggle the entire sheet, the unwrapped rows will still not wrap. The individual cells that do not wrap seem to have the wrap line box checked, too.

    Does anyone know how to make all the lines wrap?

    Thanks a lot! I sure appreciate your help.

    Lester
    Last edited by albuck; 04-02-2010 at 02:09 AM. Reason: solved

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Word wrap problem with .xls output of Google Docs

    You need to set the rows to autofit.

    select all populated rows by their row numbers, then double click one of the lines between the row numbers OR click the Format drop down on the home ribbon and select AutoFit Row Height.

  3. #3
    Registered User
    Join Date
    04-01-2010
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Word wrap problem with .xls output of Google Docs

    Great, that worked perfectly!

    Thanks so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1