see different regions of worksheet in Excel

Q118. Is there any way I can see more region of my WorkSheet?

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 excel see different regions of worksheet

 

You can find similar Excel Questions and Answer hereunder

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

2) How can I protect / unprotect WorkSheet using VBA?

3) How can I prevent users from seeing / accessing my macro code?

4) How can I save a WorkSheet as a new WorkBook using VBA?

5) I have 2 sets of lists from 2 different reports - how can I select the cells with differences?

6) How can I plot 2 series on the same chart with different scales / measurement unit for Values (Ex: Pareto chart)?

7) How can I remove Outline from my WorkSheet?

8) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

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

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

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

12) How can worksheet functions be accessed in VBA?

13) How to change the color of gridlines in a worksheet in Excel

14) How can I loop through all WorkSheets and get their names using VBA?

15) How can I identify all cells with Data Validation in my WorkSheet?