I have the pivot chart and would like to copy and paste it so that all fields are filled
G gianna Nov 3, 2004 #1 I have the pivot chart and would like to copy and paste it so that all fields are filled
D Debra Dalgleish Nov 3, 2004 #2 Select the pivot table. Choose Edit>Copy Select the cell where you'd like to paste the copy Choose Edit>Paste Special Select Values, click OK There are instructions here for filling the blanks: http://www.contextures.com/xlDataEntry02.html
Select the pivot table. Choose Edit>Copy Select the cell where you'd like to paste the copy Choose Edit>Paste Special Select Values, click OK There are instructions here for filling the blanks: http://www.contextures.com/xlDataEntry02.html
