• Excel Book Excerpt

Excel Fit a Slightly Too-Large Value in a Cell

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Fit a Slightly Too-Large Value in a Cell

Problem: I just printed 10 copies of the 20-page report for a meeting. Some numbers printed as ##### instead of numbers.

Strategy: Excel shows the ### when the number is too big for the cell. But, numbers will sometimes fit on the screen and not fit when you are printing.

LE10001188.jpg 

Figure 1147 Annoying [pound, hash, or number] signs.

To solve this problem, you can use Excel’s Shrink to Fit option. To use it, you select the numeric columns. Press Ctrl+1 to access the Format Cells dialog. On the Alignment tab, you choose Shrink to Fit from the Text Control section.

Results: The cells will be displayed in a smaller font when they become too wide for the column. This is preferable to having the numbers displayed as ######.

LE10001189.jpg 

Figure 1148 Choose Shrink to Fit.

LE10001190.jpg 

Figure 1149 The small font for 10,205,685 is preferable to #####.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: