Formatting

  • Thread starter Thread starter mrogge2895
  • Start date Start date
M

mrogge2895

Is there a way to format more than one field at a time in a pivot table?
 
Hi,

A little more detail would be helpful.

You can highlight the entire table and click the Bold button
You can use the Ctrl key to select multiple ranges and then do any
formatting you want.
You can use any of the 220 methods of selecting in the spreadsheet and then
apply a format to that selection
You can use the Selection options on the PivotTable menu
You can use the black selector arrows to select various items and then format

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
You must log in or register to reply here.

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

Pivot Table Formats 2
Pivot Table - NUMBER FORMAT option does not appear in field settin 3
Pivot Table date format 1
Field Formatting in Pivot Tables 1
Pivot Table - Currency Format 1
Mass format change of 'data' in pivot table 1
Excel 2003 Pivot Formatting 2
Pivot Table Change to US Date Format - Why? 2

Back
Top