Forum Discussion
Solved
How to anchor Pivot Table Fields in Excel 365, Windows 10
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...
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.
I figured out if you just double-click around the header, it'll automatically reattach on the right hand side.
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 😞
Is that with any pane (e.g. Help, whatever) and on any file or only for that specific one?
- Not sure about other panes, but once the pivot field got detached - it stays detached in all files I use.
