That's generally what I do. I like the floating window though. Neat trick. It would be great to keep it visible as the page scrolls automatically. As a general rule on my work, I normally add an extra row the top and on the left side. I use SUBTOTAL to get metrics in the top row. That way if the data is added to or even filtered, the metrics will update.
i never knew this. i can find use for it
Or just make the frozen row higher and leave it there. Don't have to keep moving it.
The frozen row works only for the top rows. But if you want to float cells in the middle or at the bottom the you need a watch window.
I understand, but if you just want to constantly see the totals or other metrics, just leave it at the top where they will always be visible.
Now I get it. This is a good Idea and it saves time.
That's generally what I do. I like the floating window though. Neat trick. It would be great to keep it visible as the page scrolls automatically.
As a general rule on my work, I normally add an extra row the top and on the left side. I use SUBTOTAL to get metrics in the top row. That way if the data is added to or even filtered, the metrics will update.