Printing a pivot table - Problem with Page Set-Up.

dmagnus

Board Regular
Joined
Dec 16, 2005
Messages
66
I am using Excel 2003. I have a pivot table with COUNTRY in the page field. After I've selected (ALL) in the page field, I want to print the entire pivot table on 1 page wide by 25 pages tall. So I highlight the entire cell range, select file-print area-set print area. All is good.

But then I select a different value in the page field, say "GER", and the pivot table is only 2 pages tall. But if I decide to print, it will print all 25 pages, 23 blank ones (because of the set print area).

Is there a way to automatically print only the active table and not rely on having to set print area each time a different value in the page field is selected?
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,119,264
Messages
5,577,076
Members
412,762
Latest member
sienweiw
Top