In an Excel search, “zh” usually means Chinese: it is the two-letter language code commonly used for Chinese, not a special PivotTable setting or feature. An Excel PivotTable is called 数据透视表 in Simplified Chinese and commonly 樞紐分析表 in Traditional Chinese; you can create and use one with the same basic steps regardless of the display language.
What “zh” means for an Excel PivotTable
The letters “zh” are a language tag, often appearing in language settings, software documentation, or locale identifiers such as zh-CN and zh-TW. The extra letters in those examples help identify a regional language variant. Seeing “zh” does not mean that a workbook has a different kind of PivotTable, or that a feature must be switched on.
Microsoft Excel localizes its ribbon labels and help text. In Simplified Chinese, PivotTable is generally labeled 数据透视表; in Traditional Chinese, a common label is 樞紐分析表. Exact wording can vary by language variant and product build. If a tutorial uses English menu names while your ribbon is Chinese, look for the corresponding command under the Insert tab (插入), rather than expecting a separate “zh PivotTable” mode.
A PivotTable is an interactive summary of records in a worksheet. It can total sales by region, count orders by status, or compare monthly results without requiring you to write a formula for every group. The original records remain in the source range; the PivotTable displays a rearranged summary based on fields you choose.
What a PivotTable can summarize
Imagine a sales list with one row per order and columns for Date, Region, Product, Salesperson, and Amount. A PivotTable can add Amount by Region and Product, count orders by salesperson, or show monthly totals. You can change the arrangement by moving fields between areas, which is why it is called a pivot table: the same records can be viewed from different angles.
The PivotTable Fields pane divides fields into four areas:
- Filters: filters the whole report by a field, such as Year or Region.
- Columns: lays categories across the top, such as product names.
- Rows: lists categories down the side, such as regions or salespeople.
- Values: calculates a summary, such as the sum of Amount or count of orders.
Text fields placed in Values are usually counted, while numeric fields are usually summed. Excel may choose Count instead of Sum when a numeric-looking column contains text or blank values that affect how Excel interprets the data. You can change the calculation through Value Field Settings, but first check that the source column contains the intended data type.
Create a PivotTable in Excel for Microsoft 365 on Windows
For the standard Windows desktop version of Excel for Microsoft 365, begin with a clean list: one header row, one record per row, and no completely blank rows or columns inside the data. Click a cell in the list, then use the following steps:
- Select Insert > PivotTable.
- In the Create PivotTable dialog, confirm the Table/Range field includes the full source data.
- Choose New Worksheet to place the report on a separate sheet, or choose an existing worksheet and specify a destination.
- Select OK. The PivotTable Fields pane appears beside the new report.
- Drag fields into Rows, Columns, Values, or Filters, or select their checkboxes and adjust their placement.
For a simple regional sales summary, put Region in Rows and Amount in Values. Excel should display the total amount for each region and a grand total. Add Product to Columns to compare product totals within each region. If the totals look wrong, open the field’s menu in the Values area, choose Value Field Settings, and check whether the summary is Sum, Count, or another calculation.
On Excel for the web, the Insert tab also provides a PivotTable command, though the exact dialog and available controls can differ from desktop Excel. On Mac, use the Insert tab and choose PivotTable; the dialog and field pane may be arranged differently from Windows. Localized installations show translated ribbon names, but the underlying task is the same: select a source and assign its fields to the report areas.
Using Chinese-language Excel
If Excel’s display language is Chinese, the main challenge is matching translated labels to the terms in an English guide. The command to insert a PivotTable is on the Insert tab, labeled 插入 in Simplified Chinese. The corresponding PivotTable command is usually 数据透视表 in Simplified Chinese, or 樞紐分析表 in Traditional Chinese. The field areas are also translated, so use their positions and functions—not only a literal translation—to identify them.
Language display is separate from the language and regional settings that affect dates, number formats, and sorting. For example, changing Excel’s display language does not automatically convert date values stored as text into real Excel dates. Likewise, a PivotTable can display Chinese category labels even if Excel’s menus are in English. The workbook’s data and the application’s interface language are distinct.
If you are following instructions written for another language, use Excel’s search box or look for the familiar ribbon tab and icon. You can also temporarily change Office’s display language through its language preferences if the desired language is installed and available for your account. That changes interface labels, not the data or the PivotTable’s underlying calculations.
Prepare source data for reliable results
PivotTables work best with rectangular, tabular data. Each column should describe one kind of information, and each row should represent one record. For example, keep a single Amount column rather than splitting amounts into separate columns for each region. Avoid merged cells in the source, decorative title rows above the headers, and repeated subtotal rows within the list.
- Give every column a unique, nonblank header, such as Date, Region, and Amount.
- Keep each field consistent: do not mix dates with notes or numbers with text labels in one column.
- Use one row per transaction or other record, and do not insert manual subtotals between records.
- Check for trailing spaces or inconsistent spellings, such as “North” and “North ”, which can appear as separate categories.
Converting the source list to an Excel Table can make the source easier to maintain. Select a cell in the data and choose Insert > Table, then confirm whether the table has headers. When new rows are added to the table, the PivotTable’s source can include them after a refresh. A PivotTable does not necessarily update its displayed results automatically as source values change.
Refresh, filter, and format the report
When records change, refresh the PivotTable to recalculate its summary. Click inside it and choose PivotTable Analyze > Refresh on Windows. To update all PivotTables in the workbook, use Data > Refresh All. Excel for Mac and Excel for the web also provide refresh commands, but ribbon labels and available options can vary. A refresh updates the report from its source; it does not repair errors in the source data.
Use the filter arrows beside row or column labels to show selected categories. A field placed in Filters provides a report-level filter, while a slicer offers clickable buttons for filtering supported PivotTable fields. To add one in desktop Excel, click the PivotTable and use PivotTable Analyze > Insert Slicer. Date fields may also be grouped by months, quarters, or years when Excel recognizes their values as dates. If grouping is unavailable, inspect the source for text dates, blank entries, or inconsistent values.
Formatting a PivotTable is separate from changing its calculations. The PivotTable Design tab offers layout and style choices, while Number Format can set a useful display such as currency or a fixed number of decimal places. Apply number formats through the value field’s settings when you want the choice to persist as part of the PivotTable field, rather than relying only on formatting individual cells.
Common problems and what to check
A PivotTable showing Count when you expected Sum is often a source-data issue. Check whether amounts are stored as text, whether a column contains a mixture of numbers and text, or whether the wrong field was placed in Values. Correct the source consistently, then refresh. Changing the summary to Sum cannot make text entries behave like valid numeric amounts.
Missing new records commonly mean the PivotTable source does not include the added rows. An Excel Table is a practical way to make a growing source more manageable; otherwise, check the source range in PivotTable Analyze and change it if needed. After expanding the source, refresh the report. A blank or misidentified field may instead indicate a missing header or an unexpected empty column in the selected range.
Duplicate-looking categories are often caused by inconsistent source values, such as extra spaces, spelling differences, or text that looks like a date but is stored differently. Clean the source field, then refresh. Also remember that filtering a PivotTable changes what is displayed, not the underlying records. If totals seem incomplete, check both report filters and the selected categories in row or column filters before drawing a conclusion.
PivotTable versus formulas and charts
A PivotTable is useful when you need to explore and rearrange summaries quickly, especially for a list with many records and multiple categories. It is less suitable when a report must follow a fixed custom layout or when calculations depend on specialized logic that the standard summary functions do not express conveniently. Formulas can provide more direct control over individual cells, but maintaining many separate formulas may take more work as categories change.
A PivotChart visualizes PivotTable results and can make comparisons easier to see; it is not a replacement for checking the underlying numbers. For a small, stable summary, a regular chart or a few formulas may be simpler. For repeatable reporting from a larger table, a PivotTable is often a practical starting point. The right choice depends on whether the priority is flexible exploration, a custom calculation, or a presentation-ready view.
Frequently Asked Questions
Does “zh” mean PivotTable in Chinese?
Not by itself. “zh” is a common language code for Chinese. The PivotTable feature is labeled 数据透视表 in Simplified Chinese and commonly 樞紐分析表 in Traditional Chinese.
How do I say Excel PivotTable in Chinese?
In Simplified Chinese, the usual term is 数据透视表. In Traditional Chinese, 樞紐分析表 is a common localized term. The exact wording can depend on the regional language version.
Why does my PivotTable show Count instead of Sum?
Excel may interpret the source field as text or find mixed data types, so it counts entries instead of adding them. Check and correct the source values, refresh the PivotTable, and confirm the calculation in Value Field Settings.
Why did new rows not appear in my PivotTable?
The source range may not include the new rows, or the PivotTable may simply need refreshing. Check the selected source range, consider using an Excel Table for expanding data, and refresh the report.
Does a PivotTable update automatically when its source changes?
Do not assume it does. Refresh the PivotTable or use Data > Refresh All to update results from changed source data. Refreshing will not fix incorrect or inconsistently formatted source entries.
Related
- Accounting Trial Balance Worksheet: How It Works
- Google Sheets SPLIT Function: How to Separate Text
- Oracle Split String Example: SQL Methods That Work
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Proper Excel Chart Creation: A Step-by-Step GuideTo create a proper chart in Excel for Microsoft 365 on Windows, arrange your data in a clear…
- Year-on-Year Comparison Chart Excel Template GuideA year-on-year comparison chart Excel template puts the same measures for two or more years side by side,…
- Can You Make an Org Chart in PowerPoint?Yes. In PowerPoint for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then…
- Excel Half Circle Chart: How to Create OneTo make a half-circle chart in Excel, create a doughnut chart with two visible values and a third…
- Excel Chart Not Displaying Data Correctly? How to FixIf an Excel chart is skipping, mislabeling, or mis-scaling data, select the chart and check Chart Design >…
- Excel Chart Horizontal Line: Add a Constant or TargetTo add a horizontal target or constant line to an Excel chart, add a new data series whose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.