Here is how to do that with just two clicks! To be honest, this button is not very hidden. But still, most Excel or Office users have never tried it out. In my Excel trainings , even advanced users admit that they have never heard of it — and happily incorporate it into their daily routines.
Now, the Excel file is open in two windows. You can also see that by the small number 1 and 2 or even more in the top of the Excel window, next to the file names. The best: This does not only work with Excel. Do you want to change the arrangement, for example two windows on top of each other? Click on it on the View ribbon and you will see the window on the right. When you have arranged the Excel windows as shown above, you can even scroll both windows at the same time.
This is even easier: See two different files next to each other. Just use the same built-in Excel feature. Do you want to boost your productivity in Excel? Get the Professor Excel ribbon! Add more than great features to Excel! The good news: It works very similarly on a Mac computer. As shown above, first display the file in two windows. Click and hold the mouse down until the context menu as shown on the right opens. Image by StockSnap from Pixabay. Henrik Schiffner is a freelance business consultant and software developer.
He lives and works in Hamburg, Germany. This week we continue exploring new features in Excel Good news: starting with Excel , each of your workbooks opens in its own window, similar to Word and PowerPoint today. That means that each workbook has its own ribbon and top-level window frame that you can move and resize independent from your other open workbooks.
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. Figure 1: View side by side. In order to views sheets side by side in the same workbook , we can use the New Window feature to split the window, or also use some keyboard shortcut to view tabs on side.
You can open two sheets side by side using the New Window feature. To do this, you simply need to go to the View tab in the Ribbon and click on the New Window button. When you click on this tab, a new window of the current sheet will be open. Figure 2: Click on New Window. Please note that when you click on the New Window tab, the workbook that you are currently viewing is the one that shall be opened.
Alternatively, you can view two sheets at once using the keyboard shortcuts. Once you have created a new window, you can easily differentiate between the new and the old by looking at the title bars. In the new window, the title shall have a dash the 2, -2 while the original one shall not have it. If you want to view multiple sheets at once , then you can have a third window as -3, the fourth one as -4 and so on.
It is also necessary to remember that you have not created a duplicate file to view side by side. Instead, you have just opened a new window of the current worksheet.
This means that any changes you make to either the old or new window, should be reflected in the other window. You can also tile windows side by side in order to view two spreadsheets at the same time. To do this, all you have to do is click on the title bar and drag it to the right of the screen. If you had only two sheets open, you will just be required to click on the other one to view them on the left of the screen. But if you had many other windows open you will have to select which among them you want to view besides the current one.
0コメント