In Excel 2016 and later versions, there is a Search box above the list of fields. If you used a Recommended PivotTable layout, you will see a check mark beside the fields that are in the pivot table. In the pivot table, these are called fields. Near the top of the PivotTable Field List pane is a list of the column headings from your Excel table they appear in the same order as in the Excel table. Note: Your field list will have different fields checked, or no fields. There are no fields in the Filters area, Columns area, or Values area yet. In the field list shown below, the Region field has a check mark, and the Region field appears in the Rows area. There are three main sections sections in the PivotTable Field List:
The main purpose of the PivotTable Field List is to add or remove pivot fields from the pivot table layout on the spreadsheet. To close the PivotTable Field List, click the X at the top right of the pane.Or, on some worksheet, you might need every inch of space visible, and the PivotTable Field List takes up too much space. Sometimes, you might want to hide the PivotTable Field List, to discourage people from making changes to the pivot table layout. Note: If the full Show group is not visible, click Show, Field List (from the drop down list of commands) Then in the Show group (at the far right), click the Field List command.On the Excel Ribbon, click the PivotTable Analyze tab.If the PivotTable Field List task pane does not appear automatically, follow these steps to enable it: The PivotTable Field List pane should appear at the right of the Excel window, when a pivot cell is selected.Click any cell in the pivot table layout.Table layout, and to move pivot table fields to a specific area in the layout. You can use the field list to select fields for the pivot When you create a pivot table, and select a cell in it, by default,Ī pivot table field list should appear, at the right of the Microsoft Excel
0 kommentar(er)
