Forum Discussion
carinae31585
Sep 17, 2021Copper Contributor
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...
- Sep 17, 2021
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.
salexjohnson
Jun 08, 2022Copper Contributor
I figured out if you just double-click around the header, it'll automatically reattach on the right hand side.
carinae31585
Jun 08, 2022Copper Contributor
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 😞