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?

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 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 excel excel fit title in columns with shrinktofit

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

excel excel excel excel fit title in columns with shrinktofit

 

You can find similar Excel Questions and Answer hereunder

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

2) One of my formulas has returned an error - how can I trace the error to fix it?

3) How can I find the day of the week given a date?

4) How can I calculate depreciation of assets using Excel?

5) How can I list all files in a folder using VBA?

6) I want to force a page break at a certain row - how can I do that?

7) I conducted a test and the test scores are available - how can I get Percentile rank of students?

8) I work with a SW that returns Hex values - how can I convert them to decimal values?

9) How can I calculate depreciation of assets using Excel?

10) Autofill a b c d aa ab in Excel

11) Split string into multiple columns in Excel

12) Is there a way to easily shade alternate rows in a data range for improving readability?

13) How can I list all files in a folder using VBA?

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

15) Generate a list of unique values in Excel