How do I very nice reports from excel Please ?

[Guest]

I want to create very nice reports from excel. Any suggestions, I read
something about a report manager but I don't see in in xl 2007. Help.

 

[Pete_UK]

What do you mean by "nice"? If you have a table of numbers in your
report, you can think about having appropriate column widths (Format |
Columns | Width, or just drag the right-hand bar between column
identifiers). You might like to centre some columns of data, or orient
them to the left or right (buttons on the toolbar, or Format | Cells
then Alignment). You might like to embolden the headings, or make the
font slightly larger (toolbar button, or Format | Cells | Font). You
might like to put lines around the table (Format | Cells | Borders).
You may wish to colour the background of some of the cells (Format |
Cells | Patterns).

There are many things you can do - most of them revolve around using
the Format menu.

Hope this helps.

Pete

 

[Gord Dibben]

The Report Manager was dropped after 2002 version but can be downloaded for 2003
and 2007.

http://support.microsoft.com/kb/873209/en-us


Gord Dibben MS Excel MVP

 

[Guest]

You could look at Xcelcius
http://www.crystalreports.co.uk/crystal_xcelsius.html

That creates very nice looking reports from Excel in a .swf format.