PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO CHANGE COLUMN NAMES IN GOOGLE SHEETS

PIVOT TABLE IN EXCEL
OUR FIRST PIVOT TABLE

INTRODUCTION

PIVOT TABLE is a well known feature of EXCEL which everybody of us might have heard of. But many times we don’t know how to effectively use the PIVOT TABLE.

PIVOT TABLE is a dynamic table which we can create in Excel. We called it dynamic as we can transform it within seconds. The original data remains the same.

We know that whatever is hinged to a pivot, can rotate here and there, so is the name given to these tables.

PIVOT Table is a very powerful tool to summarize, analyze explore the data in very simple steps. Its very important to learn the use of pivot tables in excel if we want to master excel. Pivot tables give us the facility to put different simple operations on a selected data in seconds.

We have already learnt about creating PIVOT TABLES HERE.

In this article we will focus upon the frequent difficulties which users face while using the pivot tables.

PROBLEM: HOW TO CHANGE COLUMN NAME OF PIVOT TABLE IN GOOGLE SHEETS

We already learnt how to create a PIVOT TABLE . [ CLICK HERE ]

Most of the times the GOOGLE SHEETS gives the column name such as SUM OF SALES, average of sales etc.

We’ll see how we can change the column name to the desired one.

WE ASSUME THAT WE HAVE ALREADY CREATED A PIVOT TABLE.

SOLUTION:

We can see in the picture above that the PIVOT TABLE contains the column name “sum of SALES ” which is given by default by GOOGLE SHEETS.

Follow the steps to rename the column

  • DOUBLE CLICK the column name in the pivot table.
  • The COLUMN HEADER/NAME will become editable.
  • Type the name of your choice. For our example we would type the name as “SALES”.

 

 

HOW TO RENAME COLUMNS IN GOOGLE SHEETS PIVOT TABLES
STEPS TO CHANGE THE COLUMN NAME

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: