I know a little, but not much about Excel. My problem: I am…
I know a little, but...
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:
Grateful for any suggestions.