Several questions about Pivot Tables - can't find answers to

[Autin]

I have created a Dummy Workbook [had to divide each part listed below into a PDF for it to load information] and have attached it to this thread.

In the workbook you will find:
Table [this Dummy Table is what the following are based on]
Query [this Query is filtering the Table for all "ENTRY" dates are in the month of March only]
Pivot Table [this Pivot Table is based on the Query with each year listed separately]

Questions are:

1) How do I eliminate all the "total" parts [rows and columns] in the Pivot Table? They are not needed are wanted.

2) How after I remove the "total" rows, how do I add a line or two to separate each year?

3) How do I make a report on the Pivot table that fits a standard letter size sheet?

I want to THANK those that reply in advance for your assistance with an answer to these problems.

[arlu1201]

Here are my answers -
1. To remove the totals - just double click on each header, for e.g. C or P, Entry, etc. You can select None from the popup window that appears.

2. You cannot insert a line but you can use the PivotTable Tools -> Design menu to choose what layout suits you best.

3. The Pivot in itself is a report. You can print it directly or just copy the entire contents and paste special to another sheet so that the layout remains the same (the dropdowns will disappear).