To move a filter field in an Excel PivotTable, open the PivotTable Fields pane and drag the field from its current box—such as Filters—into Rows, Columns, or Values. If you mean moving the filter control’s position on the worksheet, the options depend on whether it is a report filter, a slicer, or the PivotTable itself.
What “move a filter” can mean
Excel uses the word “filter” for a few related controls, so it helps to identify what you want to move before changing the layout. A field placed in the Filters box becomes a report filter: a drop-down above the PivotTable that can limit the results shown for the whole table. A field in Rows or Columns has its own label and filter drop-down within the table. A slicer is a separate, clickable filter panel that sits on the worksheet.
These controls do different jobs. Moving a field to another PivotTable area changes how the data is arranged and summarized; dragging a slicer changes where its visible panel sits. Moving the entire PivotTable changes the table’s worksheet location, but does not relocate a field to a different area. The steps below cover each case.
Move a field to a different PivotTable area
In Excel for Microsoft 365 on Windows, select any cell inside the PivotTable to show the PivotTable tabs. Then open the field list and move the field between its four layout boxes:
- Select a cell in the PivotTable.
- On the ribbon, select PivotTable Analyze > Field List if the PivotTable Fields pane is not already open.
- In the pane, locate the field in the lower layout section. Drag it from Filters, Rows, Columns, or Values to the box where you want it.
- Check the PivotTable. If the result is not what you intended, drag the field to another box or use Undo immediately.
For example, suppose a sales PivotTable has Region in Rows, Month in Columns, and Sum of Sales in Values. If you drag Region from Rows to Filters, the row labels disappear and a Region drop-down appears above the table. Selecting a region in that drop-down limits the summarized sales. If you instead drag Month to Rows, the months appear down the side rather than across the top.
You can also add a field by checking its name in the field list; Excel places it in a default area, which may not be the one you want. Dragging it directly to the desired box gives you more control. To remove a field from the PivotTable altogether, drag it out of the layout boxes or clear its checkbox. Removing a field from the layout does not delete the corresponding source-data column.
What each area does
The four boxes determine the PivotTable’s structure. They are not simply different places to display the same filter:
- Filters: Adds a report filter above the PivotTable. It filters the whole report by the selected field, such as showing one department or year.
- Rows: Creates labels down the left side. Each distinct field item can form a row or a level in a nested hierarchy.
- Columns: Creates headings across the top. This is useful for comparing categories side by side, although too many column items can make a report wide.
- Values: Summarizes a numeric or countable field, usually by Sum, Count, or another available calculation. This area is for measures, not for a report-filter drop-down.
A field in Rows or Columns can still be filtered: its label has a drop-down for choosing which items to show. Therefore, moving a field out of Filters does not necessarily mean losing the ability to filter it. It changes the form and location of the control and also changes the report’s layout. For instance, moving Year from Filters to Columns can show several years side by side instead of displaying one chosen year at a time.
Change where report filters appear
When a PivotTable has several fields in the Filters area, Excel places the report-filter controls above it. To change their order across rows or columns, right-click a cell in the PivotTable and choose PivotTable Options. On the Layout & Format tab, use Display fields in report filter area to choose an arrangement such as Down, Then Over or Over, Then Down. The Report filter fields per column setting controls how many filter fields Excel places in a column before continuing in the next one.
This setting is useful when report filters take up too much vertical space or when you want them grouped in a compact row. It does not let you freely drag an individual report-filter drop-down to an arbitrary worksheet cell. Excel positions those controls in relation to the PivotTable. If precise, independent placement is important, consider a slicer, which can be dragged and resized separately.
Excel may adjust the PivotTable’s footprint when you change the filter-field arrangement. Check for nearby content before applying a layout that could occupy additional rows or columns. If the PivotTable is close to another table or notes, leave room so the revised layout does not collide with them.
Move or reposition a slicer
A slicer is a worksheet object, not a field in the Filters box. To add one, click the PivotTable and choose PivotTable Analyze > Insert Slicer, select the field, and confirm. To reposition an existing slicer, click its border and drag it to a clear area of the sheet. Drag a sizing handle to change its dimensions. Its buttons filter the connected PivotTable, while its location is independent of the PivotTable’s row and column layout.
Slicers are helpful when a report will be used by other people, because the available choices are visible without opening a drop-down. They can occupy substantial worksheet space, particularly when a field has many items. If a slicer does not affect the PivotTable you expect, check its report connections: select the slicer and use Slicer > Report Connections (the command may be labeled PivotTable Connections in some Excel builds) to select the PivotTables it should control. This is especially relevant when a workbook contains multiple PivotTables.
Move the entire PivotTable instead
If the issue is that the PivotTable is in the wrong part of the worksheet, use the move command rather than rearranging its fields. Click inside it and choose PivotTable Analyze > Actions > Move PivotTable. In the dialog, choose a destination on the current worksheet or a new worksheet, then confirm. This relocates the PivotTable as a unit; it does not change which fields are in Filters, Rows, Columns, or Values.
Before moving it, consider formulas or charts that refer to the PivotTable’s existing cells. Excel may update some references when a PivotTable is moved, but a workbook can also contain fixed cell references or layout-dependent formulas that need review. Moving the table does not move a separate slicer automatically in every situation, so check the slicer’s position afterward.
Common problems and how to avoid them
- The field list is missing: Select a cell inside the PivotTable, then use PivotTable Analyze > Field List. Clicking outside the PivotTable can hide the contextual ribbon tab.
- The field appears in the wrong area after checking it: Excel chooses a default placement when you check a field. Drag it into the intended box rather than assuming it will become a report filter.
- The report filter seems to show only one choice: Open its drop-down and look for Select Multiple Items if you need to include more than one item. Choosing multiple items changes the filter behavior, but the control remains a report filter.
- Moving the field changes the report more than expected: Rows and Columns organize categories; Filters selects which records contribute to the displayed report. Moving a field changes the PivotTable’s structure, so totals and visible categories can appear differently even though the source data has not changed.
- New source-data items do not appear: Refresh the PivotTable using PivotTable Analyze > Refresh. Refreshing updates the PivotTable from its source; it is separate from moving a field between layout areas.
- The report filter cannot be positioned freely: That is normal for a report filter. Use the PivotTable Options layout settings to arrange multiple report filters, or use a slicer when you need a movable on-sheet control.
On Excel for Mac, select the PivotTable and look for the contextual PivotTable tab and field-list command; exact ribbon labels and dialog presentation can vary slightly by release. Excel for the web also supports editing PivotTable fields, though the pane and available commands can differ from desktop Excel. If a specific layout option is absent in the web interface, open the workbook in the desktop app for the Windows steps described above.
Which filter layout should you choose?
Choose the area based on how readers need to explore the report. Use Filters when a field should apply to the entire PivotTable but does not need to appear as a row or column category. Use Rows when readers benefit from scanning categories vertically, and Columns when a small number of categories are easier to compare side by side. Use a slicer when the control should be prominent and easy to click, especially in a presentation-style summary.
For example, a manager reviewing sales by product and month might put Product in Rows, Month in Columns, and Sales in Values. If the manager usually reviews one region at a time, Region is a sensible report filter. If colleagues need to switch regions frequently and should see the available choices at a glance, a Region slicer may be clearer. There is no universal best placement: the right choice depends on the number of items, the report’s dimensions, and how people will use it.
Frequently Asked Questions
How do I move a PivotTable filter from the top into rows?
Open the PivotTable Fields pane and drag the field from Filters to Rows. The report-filter drop-down will be replaced by row labels, and the PivotTable will expand to show the field’s items.
Can I move a PivotTable filter to a different cell?
Not as an independent report-filter control. Excel positions report filters above the PivotTable. You can arrange multiple report filters in PivotTable Options, move the whole PivotTable, or use a slicer if you need a separately positioned control.
How do I move the filter drop-down from the top to the side?
Drag its field from Filters to Rows or Columns in the field list. That changes the field’s role in the report; it does not merely relocate the same drop-down. A row or column field has its own label filter.
Will moving a field delete data from my source table?
No. Moving or removing a field in the PivotTable layout changes the report, not the underlying source-data column. The source data remains available to the workbook.
Can I move a slicer without moving the PivotTable?
Yes. Click the slicer’s border and drag it to another worksheet position. You can also resize it with its handles; its connection to a PivotTable is separate from its location on the sheet.
Related
- Excel Number Format: How to Show Zero as Blank Cells
- Excel Number Format: Red Negative Numbers in Brackets
- Excel Number Format for Negative Numbers in Parentheses
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Combo Chart Not Working? Fix the Common CausesTo create a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert >…
- How to Add Superscript in an Excel Chart LegendTo add superscript to an Excel chart legend, put the appropriate Unicode superscript character in the chart’s series…
- Excel 100% Stacked Lines in a Combo ChartYes, you can combine percentage lines with another chart type in Excel, but the most dependable method is…
- Excel Format Chart Area Size Greyed Out? FixesIn Excel for Microsoft 365 on Windows, a greyed-out chart-area size control usually means Excel is not treating…
- Excel Chart Data Labels in Millions: Number FormatTo show Excel chart data labels in millions, select the labels, open Format Data Labels, then under Number…
- Half Circle KPI Chart in Excel: Build It Step by StepTo create a half-circle KPI chart in Excel, enter the KPI value, the amount remaining to its target,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.