Ever needed to freeze panes while working with a large number of parameters?
In my excel sheet when I use a large number of parameters I need to keep some of my cells as a constant view wherever I go on the sheet.
For example on my Road model I have to keep the dates as a constant view when I look at the profit and loss or cash flow parameters for the model.
For this I use the freeze pane option. This option lets me freeze a particular part of the sheet, while I am free to navigate through the rest.
NO known shortcut to freeze panes. You can check for freeze options in tools
How is this useful?
I can keep a section of the sheet constant while comparing it to the other section that can be scrolled.