• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Q&A

Q1:The cell references in the Range box in the first PivotTable and PivotChart Wizard dialog box are wrong. What next?
A1: If the range is incorrect, click in the Range box and type the correct cell references. A quick way to specify the range in the Range box is to highlight the range in the worksheet.
Q2:I want to change the data in the pivot table, but Excel won't let me. What can I do?
A2: Excel doesn't allow you to change the data directly in the pivot table, but you can change the data in the source, such as the Excel list. After you make the changes, click the Refresh External Data button on the PivotTable toolbar to update the data in the pivot table, reflecting the changes you made in the source list.
Q3:After I create a pivot table, can I change the way the data is arranged, or do I have to create a new table?
A3: It's never too late. You can change the data arrangement by clicking the PivotTable Wizard button on the PivotTable toolbar and then clicking the Layout button. Drag the field buttons off the diagram to start fresh. Then drag the field buttons back to diagram to rearrange the data.
Q4:What can I do with the field buttons in the PivotTable Field List window?
A4: You can drag them to the pivot table to change the arrangement of your data quickly.
Q5:What if I want to show only the totals in my pivot table report?
A5: After selecting the data item, just click the Hide Detail button on the PivotTable toolbar to show only the totals and hide the detail information. When you want to display the detail again, click the Show Detail button on the PivotTable toolbar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint