Tips - How to put PivotTable Field List back at its Original Position?

01/04/2020 2 0

Have You ever struggled to put PivotTable Field List back at its Original Position?
*Original Position - right-side of the worksheet, as highlighted in the following picture:

If Your answer is Yes, You should find the following helpful.

Q) How to move PivotTable Field List back at its Original Position?
A) Double-click on its Header. *Header = where PivotTable Fields is written
PivotTable Field List could be anywhere on the worksheet. If You double-click on its Header, it will move back to its Original Position.

Note: closing and re-showing Field List will not put Field List back at its Original Position. Field List will re-show where it was just before it was closed.

2 Like 0 Dislike

Follow 2

Mrs Sharma | 13/04/2020

Thank You, Ankur.

0 0

Other Lessons for You

How to install Analysis ToolPak in Excel

The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis. To load the Analysis ToolPak add-in, execute the following steps. 1....

Dheeraj Kushwaha

1 0

VBA Function - INSTR

INSTR works similar to FIND function in Excel. INSTR search for specific text in a given text and returns the position number of what you are searching for. Syntax: InStr( , string, searchingfor, ) Sub...

Karthik Dale

0 0

Mail Merge In Word

Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more user information stored in a list, database, or spreadsheet. Mail Merge is most often used...

ITech Analytic Solutions

0 0

Learning excel complex function by using simple steps

Step 1: Understand and practice the individual excel functions thoroughly Step 2: Split the problem statement into N number of small pieces. Step 3: Use individual functions to solve the small piece...

Umasankar Natarajan

0 0

Benefits Of E-Learning

From an organizational point of view, e-learning courses can be conducted by trainers in one location and it can benefit employees across continents in different time zones. This can bring down training...

Edusmart Skills

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.