Fit title in columns with shrinktofit in Excel
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.