How to anchor Pivot Table Fields in Excel 365, Windows 10

[carinae31585]

Hi,

I accidentally detached the Pivot Table Fields item from the right side of the Excel screen. Now it's floating and disappears every time the cursor is not set within the pivot table.

How can I fix this and re-anchor the Pivot Table Fields back to the right side of the screen?

Thanks!

[#2]

@carinae31585 Just drag it to the right-hand side of the screen and it should "attach" itself again.

[#3]

Hi Riny,
I already tried that, just as double-clicking, exploring various menus - no success :(

[#4]

@carinae31585 Strange. Works on my set-up. But, just to be sure. Drag it all the way to the right, as if you want to drag it off the screen. It snaps back into place as soon as the cross-hair touches the edge of the window. For me at least.

[#5]

Hi Riny,
When I drag it - it actually doesn't only go all the way to the right. I can even drag it out of Excel, please look at the screen. Any other ideas? :)

[#6]

Ok, it seems I can't attach another screenshot. But I'm able to drag it e.g. over the G Chrome window, out of Excel...

[#7 · Accepted solution]

@carinae31585 Never tried to drag it off the Excel window, but that is apparently possible when you drag quickly. I've learned something. But when I drag slowly and hold it with the cross-hair over the edge of the Excel window, it snaps back. If not for you, I've run out of ideas.

[#8]

You were right, when doing slowly it finally worked - thank you so much! :)

[#9]

I figured out if you just double-click around the header, it'll automatically reattach on the right hand side.

[#10]

@salexjohnson 

Hi,

Thanks for your replies and trying to help. Unfortunately, this happened to me again and now none of the options is working. The pivot table window keeps floating on top, I can still drag it out of the Excel window, and even moving it very slowly doesn't help :(

[#11]

@carinae31585 

Is that with any pane (e.g. Help, whatever) and on any file or only for that specific one?

[#12]

Not sure about other panes, but once the pivot field got detached - it stays detached in all files I use.