Log In
Register
Home
July 11, 2020
Offline
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
Offline
Hello Akansh
Nothing attached
have you tried freeze panes?
Purfleet
July 11, 2020
Offline
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
Offline
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)
