In Excel 2013 (which is what we have used for these examples) viewing and arranging windows has been made even easier. It allows us to position the information we need to review in any way we wish and hopefully eases our daily use of Excel. You will now be able to calculate, copy and paste and link cells between the arranged worksheets.Īs we have just seen, to view two Excel worksheets side-by-side or even multiple Excel workbooks is a very quick process. To activate another window just click inside the window and it will be activate. The active window is the window with the darker blue colour at the top of the window. You can see which one is the active window by the colour.
In the screenshot below the first window is the active window.
Only one window (worksheet) will be active. You will now have the worksheets arranged in front of you. Select your choice and tick the check-box Windows of active workbook. You have different choices of how you want to arrange the Worksheets (tiled, horizontal, vertical or cascade). The Arrange Windows dialogue box will appear. If you click two times on New Window you can arrange 3 worksheets side by side and so on. If you click one time on New Window you can arrange 2 worksheets side by side. Well there is a better way, here we will look at how to view two Excel worksheets side-by-side saving you time and reducing the potential for error.Ĭlick the View tab and click New Window. It’s not uncommon to end up jumping between different Excel worksheets/workbooks because you are comparing data, copying & pasting or even creating links. This back and forth process takes up time and can increase the risk of error. Save time and reduce errors by viewing two or more worksheets at the same time
0 kommentar(er)
