+ Reply to Thread
Results 1 to 3 of 3

Lock PivotTable Field List menu to the side

  1. #1
    Registered User
    Join Date
    04-17-2020
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    24

    Lock PivotTable Field List menu to the side

    I was moving around my field list menu and now I can't get it to return to its original location.
    In earlier versions of Excel, you could simply double-click the PivotTable Field List menu header and it would return.

    It no longer seems to work.
    Last edited by kakaNit; 04-27-2023 at 08:50 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Lock PivotTable Field List menu to the side

    Double click still works for me.

    You could also try using the Move option on the dropdown list of the floating pane. The cursor should automatically change to NSWE cursor which you can the move to the right edge of the excel application.
    As the cursor hits the edge the pane should snap back to being attached to the right edge
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-17-2020
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    24

    Re: Lock PivotTable Field List menu to the side

    Sorry for the late response, but snapping it back worked! Can't seem to use double-click, though.

    Thanks anyway!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Printing PivotTable Field List
    By plakatown in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2016, 02:47 AM
  2. Where do the fields come from in a PivotTable Field list?
    By amartino44 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 03:27 AM
  3. PivotTable Field List: Adding Columns
    By michaelweaver4 in forum Excel General
    Replies: 1
    Last Post: 03-15-2011, 10:15 PM
  4. PivotTable Field List Dialog Box in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-28-2007, 06:23 AM
  5. Can I alphabetize a PivotTable Field List?
    By Natalie 1229 in forum Excel General
    Replies: 0
    Last Post: 08-07-2006, 05:14 PM
  6. [SOLVED] Remove old selections in Pivottable row field dropdown list
    By Mark Purvis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2006, 12:00 PM
  7. [SOLVED] Shadows of the Pivottable Field List while macro is running
    By David P in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-25-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1