I have a report in crystal which looks visually pleasing (first time using it ) but when I export it to excel it looks really bad also all the lines are missing around the cells. 

What can I do in my report so I export the color of my header, bold print, lines in the report?  I know there is an option to export with just data but that looks really really plain.

please help

Also, lines will not export to Excel. All they'll do is cause empty columns and rows. However, there is a way to get them by using object borders.

Within a "row", you'll set the top, bottom, and right borders for each objects. For the object that is furthest to the left you'll also set the left border. I usually use ruler guides at the top to make sure that the right edge of one object is the left edge of the object to its right so that you get a continuous horizontal line across.

If you have multiple sections that show, set the top border for objects in the top-most section only; for everything below that leave out the top border. Make sure that the Y value for the position of the objects in a section is 0 so that they're at the very top of the section. Then make sure that the bottom of the section is up against the bottom of the objects in that section. This will make the vertical lines continuous.

-Dell