How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Zabo04 Your Own Question

Zabo04
Zabo04, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 211
Experience:  Experienced in Word, Excel, Access, Powerpoint, and Outlook.
58597962
Type Your Microsoft Office Question Here...
Zabo04 is online now
A new question is answered every 9 seconds

I know a little, but not much about Excel. My problem: I am

Resolved Question:

I know a little, but not much about Excel. My problem: I am writing a report requiring that I extract very wide tables of annual statistics from internet-published government documents and use them in slimmed-down form in the report. I delete data columns from early years, leaving a list of categories on the left and five columns of matching data on the right. I can do that, but the resulting table is crowded, and the print is too small to be read comfortably.

One particular table has very wide category columns on the left that eat up too much space on the page. I would like to break the category descriptions into two lines, so that they take up two rows but only half the horizontal space. Trouble is, the category descriptions (up to 17 words long) can't be broken.

The table involved is Table 6 at:
http://www.dhs.gov/yearbook-immigration-statistics-2012-legal-permanent-residents

Grateful for any suggestions.
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Zabo04 replied 1 year ago.

Zabo04 :

I'm downloading it now, but it sounds like you want to turn on word wrap for that column, then decrease the columns width

Zabo04 :

Word wrap will wrap the text in a cell over multiple lines in the same cell

Zabo04 :

what version of excel are you using?

Zabo04 :

That shows the column selected and wrap text selected

Zabo04 :