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".

excel see different regions of worksheet

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.

excel see different regions of worksheet

 

You can find similar Excel Questions and Answer hereunder

1) How to print a worksheet in Excel

2) How can I add a background image to a worksheet?

3) How can I add a WorkSheet and name it as required using VBA?

4) What are worksheets events in VBA. Here we explain some of the main one like like activate or deactivate

5) How can I see where page breaks occur before actually printing?

6) How can I identify the cells that are dependent on a particular cell?

7) How to do worksheet protection with VBA in Excel

8) How can I access previously auto saved versions of my current Excel workbook?

9) How do I add a shape using VBA?

10) How can I hide all comments in my WorkSheet using VBA?

 

Here the previous and next chapter