As an Analyst, I will be working on bigger data sets which may cross more than 1000+ rows in a same work sheet. I need to scroll up and down many times to see the results. It will be frustrating to scroll up and down as there are chances to get diverted easily and end up getting lost somewhere in the middle.
The Save as option will not work here as we need to save the workbook with a different name and changes can be made in the 1st workbook only. Even if we open the same workbook again without saving it we will get it as “Read Only” copy.
It will be easy only if I have multiple instances of the same excel sheet in different workbooks here and the changes made in a workbook reflects both workbooks simultaneously.
Is this possible?
The answer is YES
Today I will be sharing two small tips which I use to overcome this problem.
The two options are
Creating a new instance of same excel sheet using “New Window”
Split: This option is in the View Tab. Divides the Screen into 4 parts. You can choose whether to have a Horizontal split or a Vertical split. You can highlight a cell in any portion and scroll it keeping the other portion intact. (See the below image to understand how use the split option).
The keyboard Shortcut for Split option is Alt W H
New Window: This option is also in the View Tab. View àWindow à New Window. This creates a new copy/ instance of the same workbook with an extension 2. Any changes done in one workbook will be reflected in the 2nd sheet instantly. This is useful when working on workbooks with multiple sheets and linking up data from one sheet to other. (See the below image to understand how use the New Window option).
The keyboard Shortcut for Split option is Alt W N
Hope you find this Excel Tip useful
Don’t forget to share this post with your friends.