have used autofit to make the titles fit into the columns, but the titles are taking up lots of space. There has to be a better way…oh, now wait…there is! I can wrap the text in the column headings, so the focus is on the contents in the cell, not on the width of the column.
I select the entire row A1, and right click. I then select format cells, and click Wrap Text.
Under Text alignment, select the Vertical text box and select Top.
------------------------------
Barry Singha
------------------------------
Original Message:
Sent: Fri October 18, 2019 04:42 PM
From: SRAVANTHI G
Subject: Wrapping text in excel list column headers
Hi,
We have a report with around 8-10 columns with long headers. Column headers are wrapping in html format which is not happening in excel format , used size and overflow option , it is not working in excel. Any thoughts on this. Thanks in advance.
------------------------------
SRAVANTHI G
------------------------------
#CognosAnalyticswithWatson