When I save results in Excel 2007 format the font sometimes appears to be inconsistently sized or unreadable. How do I avoid this?

This occurs when the data in a particular cell is longer than will fit in the width of the column, and when generating the Excel 2007 output BusinessObjects tries to adjust the font to show as much of the data as possible. This isn't always desirable, and there are a couple ways to work around it:

  1. In InfoView or Webi, adjust the cell format by checking the option to "Autofit Width". Keep in mind this will increase the column width and your results may no longer fit on a page if they have previously. OR
  2. Open the download file in Excel, right click on the column, pick "Format Cells", go to the Alignment tab, and uncheck "Shrink to Fit".