Excel+Data+Shrink+it+to+Fit+the+Cell

Excel Data Shrink it to Fit the Cell You must have experienced data in MS Excel that's just a bit too long for the cell You probably got the infamous ##### to let you know that the number didn't fit. Excel has a cell formatting option called "shrink to fit." Its effects on data look like this:

What it does is reduce the font size for the data piece that's too long for the column. You can increase the column width, that is one solution. However Excel will automatically adjust the font size back up, maxing out at the original font size etc.. It is called Shrink to Fit To begin first highlight the cell(s), column(s) or row(s) that need this setting. Then open the Format Cells window by :- Right click, Format Cells or Ctrl + 1 or Format menu, Format Cells. Now select the Alignment tab.

In the Text Control section:- Select the Shrink to fit choice. Simple when you know how Yes ?  