Excel 2007 Pivot Tables - Page Field Row Height; Disable Select MultItems

D

delecto

Hi all,

Hoping for a bit of help with pivot tables in Excel 2007.

1. Is there a way to keep the page field row heights constant? As it
is now, as you select different options, the row height shrinks or
grows - looks a bit unprofessional.

2. Within the page fields, there is an option to "Select Multiple
Items." Is there a way to disable this option? My pivot tables will be
going to folks with very limited Excel skills, and I don't want them
accidentally selection multiple options.

Thank you!!

Jill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot table: select multiple data easier 0
ROW HEIGHT ADJUSTMENT IN PIVOT TABLES 0
Row Height Adjustments 3
Clear row label data in pivot table 2
Single Filter to change all Pivot Tables in a Workbook 9
Pivot Table Page Break Refresh Problem 0
Pivot Tables & Excel 2007 1
pivot tables value filter 1

Top