fit title in columns with shrinktofit in Excel
Q93. I have a column header Title that is big - I cannot increase the size of column. In Excel, how can I somehow fit the Title retaining the existing column width?
For example, in the Table below, Col C Title is pretty big. In Excel, how can I fit the Col C Title within the column width?
To do it in Excel, here is the answer:
a) Right click on "Col C" header. Click on "Format Cells".
b) "Format Cells" dialog box pops up. In the "Alignment" tab, under "Text Control", check "Shrink to fit" option. Click OK.
c) "Col C" header text shrinks to fit within the existing column width.