

July 11, 2020

Hello Mam,
I am facing a issue of fixing a data in an excel sheet. For eg. I am attaching an excel, It contains data in multiple rows and based on the data I want to evaluate certain parameters as listed in the table. I want to keep the table fixed while I scroll the data and don't want the table to vanish when I am applying a filter. Please suggest me a method apart from placing table in the top most rows and shifting my data downwards.
Thanks.


Trusted Members

December 20, 2019



July 11, 2020

I am extremely sorry for not attaching the document. Here is it. Yes I have tried freeze panes but either it restricts movement of my data horizontally or vertically or both. But I require that the data can be freely scrolled, pivoted, filtered keeping a particular table on the right fixed.


Trusted Members

December 20, 2019

Not sure it will help much, but i would add rows at the row of the data, put in the formula and then freeze panes on the headers - see attached (sheet - freeze panes)
You could experiment with the Watch Window, which I have used sparingly in the past - Highlight cells to watch > Formulas > Watch Window. See attached (sheet - Watch window)
The below link might help
1 Guest(s)
