If you press Ctrl + C and then Ctrl + Alt + V, Excel will display the Paste Special dialog box and you can then click Values and click OK. You can also copy and paste pivot table values in another worksheet or workbook as well. If you copy and paste a pivot table using Ctrl + C and then Ctrl + V, Excel will make a copy of the pivot table, not the values. The pivot table should be deleted and replaced with values.īelow is the Paste drop-down menu in Excel: Right-click any cell in the selected pivot table.To delete a pivot table and convert it to values: This can be useful if you want to share the pivot table summary information with clients or colleagues. You can delete a pivot table and convert it to values. Deleting a pivot table and converting it to values You can also delete a pivot table by deleting the worksheet on which it appears (assuming there is no other data on the sheet) or by deleting all of the rows on which the pivot table appears. However, if you have applied filters in the pivot table, Ctrl + A will not select the entire pivot table. You can select an entire pivot table by selecting a cell in the pivot table and then pressing Ctrl + A. A drop-down menu appears.īelow is the Select All command in the Ribbon: Click the PivotTable Tools Analyze or Options tab in the Ribbon.Recommended article: 10 Great Excel Pivot Table Shortcutsĭo you want to learn more about PowerPoint? Check out our virtual classroom or live classroom PowerPoint courses > Deleting a pivot table If you delete a pivot table or a source worksheet with the original data, Excel still retains the cache. When a pivot table is created from source data in a workbook, Excel creates a pivot cache in the background. You can delete a pivot table, convert a pivot table to values or clear data and customizations from a pivot table to reset it. If you have entered custom label text but want to display the data label entries that are linked to worksheet values again, you can click Reset Label Text.Delete a Pivot Table in a Microsoft Excel Workbookīy Avantix Learning Team | Updated June 19, 2020Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)Ī pivot table can be deleted in an Excel workbook in several ways. To adjust the label position to better present the additional text, select the option that you want under Label Position. To change the separator between the data label entries, select the separator that you want to use or type a custom separator in the Separator box. For example, in a pie chart, data labels can contain percentages and leader lines. The label options that are available depend on the chart type of your chart. You can also right-click the selected label or labels on the chart, and then click Format Data Label or Format Data Labels.Ĭlick Label Options if it's not selected, and then under Label Contains, select the check box for the label entries that you want to add. On the Format tab, in the Current Selection group, click Format Selection. This displays the Chart Tools, adding the Design, Layout, and Format tabs. To display additional label entries for a single data point, click the data label in the data point that you want to change, and then click the data label again. To display additional label entries for all data points of a series, click a data label one time to select all data labels of the data series. Select the existing text and then type the replacement text. The cell values will now display as data labels in your chart.Ĭhange the text displayed in the data labelsĬlick the data label with the text to change and then click it again, so that it's the only data label selected. When you do that, the selected range will appear in the Data Label Range dialog box. When the Data Label Range dialog box appears, go back to the spreadsheet and select the range for which you want the cell values to display as data labels. You can use cell values as data labels for your chart.Ĭlick Label Options and under Label Contains, select the Values From Cells checkbox.
Right-click the data series or data label to display more data for, and then click Format Data Labels.Ĭlick Label Options and under Label Contains, pick the options you want. Tip: If the text inside the data labels is too hard to read, resize the data labels by clicking them, and then dragging them to the size you want.