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?

excel fit title in columns with shrinktofit

To do it in Excel, here is the answer:

a) Right click on "Col C" header. Click on "Format Cells".

excel fit title in columns with shrinktofit

b) "Format Cells" dialog box pops up. In the "Alignment" tab, under "Text Control", check "Shrink to fit" option. Click OK.

excel fit title in columns with shrinktofit

c) "Col C" header text shrinks to fit within the existing column width.

excel fit title in columns with shrinktofit

 

You can find similar Excel Questions and Answer hereunder

1) How can i filter multiple columns simultaneously in Excel

2) Split one long column into multiple smaller columns in Excel

3) I have read that Merging cells should be avoided if possible. In Excel, how can I then make my Title appear in the center of my Data Table?

4) I have a big Table spanning across pages when printed - how do I get Excel to print titles in all pages?

5) How can I add and link a Chart Title to a cell value?

6) Split string into multiple columns in Excel

7) How can I sort data using VBA?

8) I have 2 sets of lists from 2 different reports - how can I select the cells with differences?

9) How to hide and unhide rows and columns in excel VBA

10) How to hide and unhide rows and columns in Excel

 

Here the previous and next chapter