Pivot Table Issues

Group PivotTable Values by Number Range in Excel for Mac

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

Group numeric PivotTable data into ranges in Excel for Mac.

Group PivotTable Values by Number Range in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
The user wants to organize scores, sales amounts, or other numeric data into intervals in a PivotTable.
Observed behavior
The Group command is not available when the numeric field is placed only in the Values area.
Before you start

Check that the source column contains numeric values and note the interval you want to use. Open the PivotTable Fields pane so you can change where the field appears.

Solution 1Recommended

Move the numeric field to Rows or Columns and group it

Use this method to create number ranges directly in the PivotTable.

1
Place the field in Rows

In the PivotTable Fields pane, drag the numeric field to Rows or Columns. A field cannot generally be grouped while it is only in Values.

2
Open the grouping command

In the PivotTable, right-click or Control-click a number in the field you placed in Rows or Columns, then choose Group.

3
Set the ranges

In the Grouping dialog, enter the Starting at and Ending at values and the interval in By, then select OK.

4
Add a calculation

Drag the numeric field into Values as well if you want a calculation for each range. Open the field's Value Field Settings to choose Sum, Count, or another calculation.

Move the numeric field to Rows or Columns and group it
If grouping is unavailable: Check the source column for blanks or nonnumeric entries. Some PivotTable data sources may also restrict grouping; a helper column can provide an alternative.
Create number ranges in WPS Spreadsheets

Group numeric data with a helper column in WPS Spreadsheets

Create interval boundaries in your source data, then use them as row labels in a WPS Spreadsheets PivotTable.

  1. 1. Open the workbook: Open your spreadsheet in WPS Spreadsheets and locate the numeric source column.
  2. 2. Create interval boundaries: Add a Range column and enter =INT(A2/10)*10 in the first data row, replacing A2 with the numeric cell. Copy the formula down the column.
  3. 3. Insert a PivotTable: Select the source data, including the new Range column, and choose Insert > PivotTable.
  4. 4. Arrange the fields: Drag Range to Rows and the numeric field to Values. Choose Count or another calculation for the Values field.
Organize scores or amounts into consistent numeric intervalsOpen and edit Microsoft Excel XLSX and XLS filesSummarize each interval with a PivotTable calculationUse a familiar spreadsheet interface
QA img-9

Frequently Asked Questions

Why can't I group a field in the Values area?

The Values area contains summarized calculations rather than row or column labels to group. Drag the original numeric field to Rows or Columns, then right-click a number and choose Group.

Can I count scores in each number range?

Yes. Group the score field in Rows, add the same field to Values, and use Value Field Settings to select Count.

What should I check if Excel still won't group the numbers?

Check the source column for blanks or text mixed with numbers, then refresh the PivotTable. If the data source does not support grouping, add a range helper column and use it in Rows.

How do I change the size of a numeric range?

When grouping a row or column field, enter the desired interval in the Grouping dialog's By box. For a helper column, change the interval in the formula, fill it down, and refresh or rebuild the PivotTable.