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.
Hello Akansh
Nothing attached
have you tried freeze panes?
Purfleet
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.
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
https://www.myonlinetraininghub.com/no-more-back-and-forth-between-tabs
