answersLogoWhite

0

If you select the main text headings, they will be included in the pivot table as headings. You can type into any cell in a pivot table that has text, though not ones that have values.

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

What is a powerful tool for summarizing in a table in Excel?

A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.A pivot table.


Can A Pivot Table be sorted and filtered?

Yes, you can both sort and filter a pivot table.


What is the short cut key for pivot table in MS Excel?

There are many shortcut keys associated with Pivot tables. These are after the table has been created. There is not a standard key to create a Pivot table. You would normally use the Pivot table wizard.


What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed?

format riport


To make changes to Pivot table data you must do what?

You would change the source data and refresh the pivot table.


Where can one buy a pivot table?

A pivot table is a tool used in data analysis to look at variable data. The easiest way to create a pivot table is to use the pre-made template on Microsoft Excel.


What cannot exist in Excel without an associated Pivot Table?

A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.A pivot chart.


What part of the ribbon is especially for working with Pivot Tables?

In Excel, the part of the ribbon specifically for working with Pivot Tables is the "PivotTable Analyze" tab (formerly known as "Options" in some versions). This tab appears when you select a Pivot Table and contains tools for modifying the Pivot Table, such as changing the data source, refreshing data, and applying different calculations. Additionally, the "Design" tab, which also appears when a Pivot Table is selected, allows for formatting and styling options for the Pivot Table.


What are the softwares that can create pivot table?

Software used to create pivot tables include XLSTAT Pivot software and XLSTAT-Pro.


What are Column Labels in the areas of a Pivot Table?

Each pivot table is different, so it depends on how you have it laid out and what data is in it. Pivot tables are very flexible, so you can switch around the data and column headings could become row headings and the data can change. Column headings will indicate what the data in a particular column in the pivot table is.


What is the use of pivot table and chart?

We use a Pivot Table for a different view of the data in a tabular as well as pictorial form without any changes in the original data.


How do you delete pivot table in excel?

Select the entire table and press the Delete key.