See different regions of worksheet in Excel
For example, I have a big WorkSheet - I find it difficult to enter information that is dependent on some other information elsewhere in the WorkSheet.
Is there any way I can see more region of my WorkSheet so that I can avoid lot of scrolling?
To do it in Excel, here is the answer:
a) Click on "New Window" under "View".
b) A separate Window is opened that can be independently controlled. The newly added window is identified by a ":2" suffix against the File name in Title Bar as shown below.
In the new window, the visible region could be set up different from the original window thereb increasing the total range of visible cells.