Hi I am using Excel 2007 and I like the gradient fill ability. I have a number of columns and I want to put color bands on every second row to make it easier to identify which row I'm on. Right now I just have it in solid colors. I've tried the gradien fill from left to right (left being a color and right being white).

Wrap text works fine on merged cells. Your problem is.Rows with Merged cells will not Autofit. You need VBA code to do that. If you must use merged cells here is some event code that will autofit merged with wrap text. Right-click on the sheettab and 'View Code' Copy the code and paste unto that sheet module. Uninstall parallels 6 for mac.

'NOTE: Cells must be formatted to wrap text and autofit.