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.
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