Pivot Table Borders... Keeping borders when changing page fi

Jud Lind · May 16th, 2002, 01:32 PM

How do you keep borders in the data area when changing the page field?

I read large tables, and need the lines!

Thanks,
Jud

Mark W. · May 16th, 2002, 02:04 PM

Right click on your PivotTable and choose the Select | Enable Selection command from the popup menu prior to applying your borders.

[ This Message was edited by: Mark W. on 2002-05-16 16:02 ]

Jud Lind · May 16th, 2002, 02:50 PM

When I do that, my selection options are different than the "norm." How do I select the data area only... so that when I have a different size pivot I don't get extra lines- or not enough?

(i.e., I change the page area. The Data for a specific area differs from the original....)

Mark W. · May 16th, 2002, 05:06 PM

Perhaps I don't understand your question. When you press the Enable Selection button (see my instructions above) you can also press the Data button.

Jud Lind · May 16th, 2002, 05:09 PM

I'll play with it a bit later, and respond with outcome tomorrow.
Thanks,
Jud

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 01:32 PM	#1
Jud Lind New Member Join Date: May 2002 Posts: 4	How do you keep borders in the data area when changing the page field? I read large tables, and need the lines! Thanks, Jud

May 16th, 2002, 02:04 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Right click on your PivotTable and choose the Select \| Enable Selection command from the popup menu prior to applying your borders. [ This Message was edited by: Mark W. on 2002-05-16 16:02 ]

May 16th, 2002, 02:50 PM	#3
Jud Lind New Member Join Date: May 2002 Posts: 4	When I do that, my selection options are different than the "norm." How do I select the data area only... so that when I have a different size pivot I don't get extra lines- or not enough? (i.e., I change the page area. The Data for a specific area differs from the original....)

May 16th, 2002, 05:06 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Perhaps I don't understand your question. When you press the Enable Selection button (see my instructions above) you can also press the Data button.

May 16th, 2002, 05:09 PM	#5
Jud Lind New Member Join Date: May 2002 Posts: 4	I'll play with it a bit later, and respond with outcome tomorrow. Thanks, Jud