You can use Excel's filtering functions.

Or Data Group and Outline.

Also check out Custom Views to set up printing views.


Gord Dibben MS Excel MVP

On Tue, 4 Aug 2009 07:57:01 -0700, Webtechie
wrote:

Hello,

I have developed a big spreadsheet complete with userforms and lots of vba
code. The userforms query and get the information keyed in nicely.

Now I want to create reports in Excel. Is the only answer to ship over to
Crystal Reports. Can't you do reports in Excel?

1) I know how to create header and footer
2) Can you group or sort a report in Excel?
3) Anyone know of reporting capabililites other than repeating columns and
rows?

Thanks,

Tony