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

VBA Tip: Repeating Emp Names N number of times using 4 different loops

Hi All,This is a requirement from one of our student and here we are posting the question along with solution (this can be achieved using 4 different loops). In Column “J” there are few employee...

Naga Satyanarayana Anantapalli

2 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

Concatenate Function

Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...

Saburudeen MA

0 0

Generate Employee Payslip using Excel & VBA Macros

yes we can generate the Payslips for each employee from a huge data in the excel. We can generate a separate Excel sheet for each employee and also can create Payslip Excel files with the names of the...

Venkata Seshasai Kanuru

1 0

Microsoft Excel

For the following data, determine the discount rate for which the total payable amount will be Rs. 45000 Particulars Qty Rate Amount LG Washing machine 2 23800 47600 Discount (%) ...

Upendra Lele

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.