Text in PivotTable Values

Show Text in the Values Section of Pivot Table

If you're familiar with Pivot Tables, then you'll know that numbers only show up in the values section...most of the time. However if you wanted to put text in the values section, there is a workaround. One involves custom formatting, but it's limited to three text entries (that are aligned to positive, negative and 0 values). Another ...

228K viewsJan 9, 2019

Pivot table Tutorial

13:36

Pivot Table Excel Tutorial

YouTubeKevin Stratvert

5M viewsMay 21, 2019

3:25:48

How to Use PivotTables in Excel: Beginner to Advanced

YouTubeSimon Sez IT

548.9K viewsMar 28, 2023

10:15

Learn Excel Pivot Tables in 10 Minutes - A complete beginner's tutorial

YouTubeChandoo

433.8K viewsMay 17, 2021

Top videos

6:26

Show Text in Excel Pivot Table Values Area

YouTubeContextures Inc.

331K viewsApr 13, 2014

7:39

Show TEXT in VALUES AREA of a Pivot Table | Advanced Pivot Table Trick

YouTubeExcel Bonanza

26.6K viewsNov 9, 2023

4:33

How Can I Show Text in the PivotTable Values Area Instead of Numbers? | Display Unique Text Values

YouTubeChester Tugwell

238.1K viewsJan 7, 2022

Pivot table Examples

8:48

PIVOT TABLE: Excel’s Top Data Tool! Excel in Excel!

YouTubeSolteferi

47.3K views9 months ago

12:46

How to Easily Build Excel Pivot Tables from Scratch!

YouTubeTechnology for Teachers and

76.9K views9 months ago

8:36

Pivot Table Excel | Step-by-Step Tutorial

YouTubeKevin Stratvert

1.3M viewsOct 7, 2024

Including results for text in pivot table values.

Do you want results only for Text in PivotTable Values?

6:26

Find in video from 00:24Setting Up the Pivot Table

Show Text in Excel Pivot Table Values Area

331K viewsApr 13, 2014

YouTubeContextures Inc.

7:39

Show TEXT in VALUES AREA of a Pivot Table | Advanced Pivot Tabl…

26.6K viewsNov 9, 2023

YouTubeExcel Bonanza

4:33

Find in video from 03:15Editing the Measure with VALUES Function

How Can I Show Text in the PivotTable Values Area Instead of …

238.1K viewsJan 7, 2022

YouTubeChester Tugwell

Text List in Value section of Pivot Table

3:26

Find in video from 00:51Inserting a Pivot Table

Text List in Value section of Pivot Table

12K viewsAug 20, 2023

YouTubeExcel with Lee

3:22

Excel Pivot Tables - Add a Column with Custom Text

213.2K viewsMay 12, 2018

YouTubeProlific Oaktree

5:09

I Learned an Easy Way How to Show Text in the Pivot Table Values Are…

8.6K viewsJul 16, 2020

YouTubePrasad Hariharan

7:21

How to show text in values area of Pivot Tables

27K viewsJan 17, 2023

YouTubeEfficiency 365 by Dr Nitin

11:11

Find in video from 01:30Creating the Pivot Table

How to DISPLAY TEXT in PIVOT TABLE (Store Sales)!

8.7K viewsFeb 3, 2022

YouTubeThe HR Diary

0:42

Find in video from 00:20Summation of Values Field

Show text in excel pivot table values area | ADVANCED PIVOT TABLE T…

3.5K viewsNov 9, 2023

YouTubeExcel Bonanza

10:52

Find in video from 00:45Creating a Pivot Table

Display Texts in the Pivot Table (!Go to Description for better video!)

29.1K viewsAug 17, 2023

YouTubeExcel Insights

5:01

Find in video from 00:22Setting Up the PivotTable

Excel PivotTables - Group Text Fields and Tips for working in Gro…

10.3K viewsDec 6, 2022

YouTubeChris Menard

3:39

Concatenate Unique Text Values in an Excel Pivot Table

37.2K viewsAug 30, 2020

YouTubeHow to Excel

10:06

How to Pivot text values in Excel [Simple Trick]

70.4K viewsApr 30, 2018

YouTubeChandoo

3:45

Find in video from 00:23Grouping Text Items

How to Group Text Items in an Excel Pivot Table

62.6K viewsJun 15, 2013

YouTubeContextures Inc.

14:48

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

15.3M viewsFeb 4, 2015

YouTubeExcel Campus - Jon

12:45

10 Advanced Pivot Table Tricks to Make you an Excel PRO

129.9K views8 months ago

YouTubeKenji Explains

39:50

Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting …

122.4K viewsNov 17, 2017

YouTubeexcelisfun

20:48

Find in video from 14:24Using CONCATENATEX to display Text in Values

Excel Text in Pivots and Power Query Magic

9.9K viewsJul 5, 2024

YouTubeAccess Analytic

11:47

Advanced Pivot Table Techniques (to achieve more in Excel)

2.3M viewsApr 8, 2021

YouTubeLeila Gharani

8:36

Find in video from 02:16Summarize Values (Sum, Max, Count)

Pivot Table Excel | Step-by-Step Tutorial

1.3M viewsOct 7, 2024

YouTubeKevin Stratvert

14:28

Pivot Table in MS Excel | Top 10 Examples of Pivot Table in MS Ex…

20.9K viewsFeb 13, 2025

YouTubeComputer Tech Academy

3:38

Find in video from 01:14Creating a Pivot Table

Excel: Pivot Table Hack - Display Actual Data Instead of Sum or Count

126K viewsJun 4, 2023

YouTubeMike Thomas

11:16

Find in video from 03:48Inserting Pivot Table

2 Quick Ways To Calculate Distinct Count With Pivot Tables

304.9K viewsSep 10, 2020

YouTubeExcel Campus - Jon

0:53

How To Show Text In PivotTable Values Area

32.9K viewsJun 20, 2023

YouTubePete - HowToAnalyst

6:11

Find in video from 05:04Repeating HP Values

How to get multiple column values in next cells in pivot table | Excel …

227.2K viewsApr 20, 2021

YouTubeThe Data Millennials

15:43

Find in video from 00:28Inserting a Pivot Table

How to Use Calculated Fields in Google Sheets Pivot Tables

38.3K viewsMay 16, 2024

YouTubeProlific Oaktree

1:05

Excel Pivot Table Values Vertical or Horizontal Quick Fix

11.6K viewsFeb 13, 2024

YouTubeContextures Inc.

15:58

Pivot Table - Text Value Field Instead of Counts - Google Sheets

72.5K viewsAug 29, 2019

YouTubeLearn Google Sheets & Excel Spreadsheets

4:38

How to Summarize the Text Data Using Pivot Table

10.9K viewsSep 10, 2021

YouTubeExcelskill Corner

See more videos

Top suggestions for Text in PivotTable Values