Tips for exporting to Excel cleanly:
1. For each "column" of data, make sure that the column header, data, and summary (if any) are the EXACT same size. To do this select all of them, right click on the one that's the size you want, select Size and Same Width.)
2. For each column of data, make sure that all of the objects start in the same position. To do this select all of them, right click on the one that's in the correct position, select Align and Lefts.
3. Avoid column headers that are on multiple lines unless ALL of the column letters wrap to the same number of lines.
4. If possible, use the Data Only export to Excel - it's not a "pretty" but it also doesn't merge cells so it's easier to work with the data.
-Dell
IP Logged
