Excel multiple windows

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 first workbook only. Is it possible to open same excel sheet in multiple windows? I will share two options which I use to overcome this problem and open same excel sheet in multiple windows confortably. This option is in the View Tab. You can choose whether to have a Horizontal split or a Vertical split. You can also highlight a cell in any portion and scroll it keeping the other portion intact.

There is a solution to that as well. If all we want is to keep the Column or Row headings visible, go under the View tab in the ribbon and click on Freeze Panes.

Three options will pop up:. What if we need more than that? Go back up to the View tab and select the Split button. Depending on the active cell placement, we will be given either two or four independent quadrants of the same spreadsheet. These can be moved around somewhat independently, allowing for multiple sections of the spreadsheet to be shown at the same time. Please email me at aduerfeldt2 unl. With a focus on industry applications and research, the online program is designed with maximum flexibility for today's working professionals.

Cancel Submit. Hope this solves the madness of what I went through for someone else. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. This site in other languages x. This functionality can improve multitasking, visibility, and analysis across workbooks. Microsoft Excel Turn data into insights.

Now that you have multiple windows, how should you arrange them? Well, there are plenty of options and below are some favorites:. Smart Snapping: Grab the top of the window, and drag it to the top, left, or right edge of your screen, then let go. The window automatically resize:.