Forum Discussion
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 I fix this and re-anchor the Pivot Table Fields back to the right side of the screen?
Thanks!
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.
12 Replies
Hmm. It seems to only reattach on the main monitor when you have a multimonitor setup :(
- 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?
carinae31585 Just drag it to the right-hand side of the screen and it should "attach" itself again.
- Hi Riny,
I already tried that, just as double-clicking, exploring various menus - no success 😞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.
