I’m using Access 2002. I can generate a nice report in Access, with color background for the header and each section. But when I export the report to Excel, (or analyze with Excel), the nice format are lost in Excel file. Each section’s header is moved to the first few columns and no color background anymore, just plain data.
Is this common? How to make the report looks the same in Excel? Do it manually?
Thanks much!!!
Is this common? How to make the report looks the same in Excel? Do it manually?
Thanks much!!!