the row labels and column labels options will available when u click on _______ button
Answers
Explanation:
Name Displays the PivotTable name. To change the name, click the text in the box and edit the name.
Layout & Format
Layout section
Merge and center cells with labels Select to merge cells for outer row and column items so that you can center the items horizontally and vertically. Clear to left-justify items in outer row and column fields at the top of the item group.
When in compact form indent row labels To indent rows in the row labels area when the PivotTable is in compact format, select an indentation level of 0 to 127.
Display fields in report filter area Select Down, Then Over to first display fields in the report filter area from the top to the bottom, as fields are added to it, before taking up another column. Select Over, Then Down to first display fields in the report filter area from left to right, as fields are added to it, before taking up another row.
Report filter fields per column Type or select the number of fields to display before taking up another column or row based on the setting of Display fields in report filter area.
Format section
For error values show Select this check box, and then type text, such as "Invalid", that you want to display in the cell instead of an error message. Clear this check box to display the error message.
For empty cells show Select this check box, and then type text, such as "Empty", that you want to display in the cell instead of a blank cell.
Autofit column widths on update Select to adjust the PivotTable columns to automatically fit to the size of the widest text or number value. Clear to keep the current PivotTable column width.
Preserve cell formatting on update Select to save the PivotTable layout and format so that it is used each time that you perform an operation on the PivotTable. Clear to not save the PivotTable layout and format and resort to the default layout and format each time that you perform an operation on the PivotTable.
Totals & Filters
Grand Totals section
Show grand totals for rows Select or clear to display or hide the Grand Total column next to the last column.
Show grand totals for columns Select or clear to display or hide the Grand Total row at the bottom of the PivotTable.
Filters section
Subtotal filtered page items Select or clear to include or exclude report-filtered items in subtotals.
Note: The OLAP data source must support the MDX expression subselect syntax.
Mark totals with * Select or clear to display or hide an asterisk next to totals. The asterisk indicates that the visible values that are displayed and that are used when Excel calculates the total are not the only values that are used in the calculation.
Note: This option is only available if the OLAP data source does not support the MDX expression subselect syntax.
Allow multiple filters per field Select to include all values, including those hidden by filtering, when Microsoft Office Excel calculates subtotals and the grand total. Clear to include only displayed items when Excel calculates subtotals and the grand total.
Note: This setting is only available for a non-OLAP data source.
Sorting section
Use Custom Lists when sorting Select or clear to enable or disable the use of custom lists when Excel sorts lists. Clearing this check box may also improve performance when you sort large amounts of data.
Display
Display section
Show expand/collapse buttons Select to display the plus or minus buttons that you use to expand or collapse row or column labels. Clear to hide the plus or minus buttons that you use to expand or collapse row or column labels. You might want to hide the plus or minus buttons when you print a PivotTable or when you display a PivotTable just for viewing.
Show contextual tooltips Select to display tooltips
Answer:
On a label filter option .
Explanation:
- Select row of column labels .
- On the Excel ribbon ,click the options tab.
- In the Action group, click select.
- Click labels and Values.
PLZ MARK ME AS BRAINLIST IF YOU LIKE MY ANSWER