Row and column fields in Excel - Step-by-Step Guide

Introduction

Row and column fields help organize data in a pivot table by placing categories in rows or columns. This makes it easier to compare and analyze information side by side.

When you want to see sales data broken down by product categories in rows and months in columns.

When you need to compare expenses by department across different quarters.

When summarizing survey results by age groups in rows and response types in columns.

When creating a report that shows employee counts by location in rows and job titles in columns.

When analyzing website traffic by source in rows and device type in columns.

Steps

Step 1: Select

- any cell inside your pivot table

PivotTable Fields pane appears on the right side of the Excel window

Step 2: Drag the desired field

- PivotTable Fields pane, from the field list

Field moves to the Rows area below

Step 3: Drag another field

- PivotTable Fields pane, from the field list

Field moves to the Columns area below

Step 4: Look at the pivot table

- worksheet area

Data is organized with row field categories down the left and column field categories across the top

Step 5: To change a field from row to column or vice versa, drag it between Rows and Columns areas

- PivotTable Fields pane

Pivot table layout updates immediately to reflect the new arrangement

Before vs After

Before

Pivot table shows only total sales without any breakdown

After

Pivot table shows sales broken down by product categories in rows and months in columns

Settings Reference

Rows area

📍 PivotTable Fields pane

Places the selected field categories down the rows of the pivot table

Default: Empty until you drag a field here

Columns area

📍 PivotTable Fields pane

Places the selected field categories across the columns of the pivot table

Default: Empty until you drag a field here

Common Mistakes

Dragging a field to the Values area instead of Rows or Columns

Values area summarizes data with calculations, not categories for rows or columns

Drag fields you want as categories to Rows or Columns areas

Placing too many fields in both row and column areas causing clutter

Too many categories make the pivot table hard to read and analyze

Limit row and column fields to the most important categories for clarity

Summary

Row and column fields organize categories in a pivot table for easy comparison.

Drag fields to Rows for vertical categories and Columns for horizontal categories.

Changing field placement updates the pivot table layout instantly.