Thursday, June 28, 2012

3 Other Methods for getting Excel Data to fit in 1 cell

If your data does not fit in the cell, try these other methods if expanding the column is not a good option:
  1. Wrap Text -  this option increases the row height and wraps the data within the current column width.  This command is found on the Home tab in Excel 2007 or 2010.  Select the cell you want to wrap and then press the "Wrap Text" command.
  2. Shrink to Fit - this option shrinks the cell contents to fit within the cell boundaries.  This command is found by clicking the dialog expander (arrow) in the bottom right corner of the Alignment grouping on the Home tab in Excel 2007 or 2010.  When you click the dialog expander, the Format Cells dialog box displays.  On the Alignment tab, click "Shrink to Fit" and then click OK.
  3. Merge - this option merges selected cells into one large cell.  This command is found on the Home tab in Excel 2007 or 2010.  Select the cells that you want to merge into one cell and then click Merge & Center in the Alignment group (to merge and center) or click the down arrow on the right of the Merge & Center command and select Merge.