Excel Windows

Excel shortcuts, including navigating multiple windows and workbooks, are covered extensively in our NYC Excel classes. For those outside New York, find and compare the best Excel classes near you or online Excel classes.

Windows 

So you can use several keyboard shortcuts to navigate around your windows, and you can also use certain commands in Windows to arrange and position your windows into different configurations that we're going to go over right now. 

For instance, I'm going to go to this sheet, and I'm going to click on a new worksheet button. I have a new sheet here. I might want to compare information in this sheet with information in the original sheet. I'm not going to be able to do that inside of one workbook, no matter how fast I click on either sheet. 

Open New Window

So what I might decide to do is open up a new window. Now just to show you that it's going to be the same window within the same workbook, what I'm going to do is say, "New Window," and I'll make this really bold and big. 

So now we know this is a new window in the same workbook. What I could do is go over to the View tab and choose New Window. What this does is it clones the existing worksheet. This is Windows Version 2, and if I restore this, you'll see I have my original window right here. What this allows me to do is click on another tab, and I'm able to look at two worksheets within the same workbook. 

Vertical Arrangement

Now, I might want to arrange these windows because I maybe don't like this particular arrangement. I want the windows to be side by side. I don't have to worry about manually making those adjustments, like trying to arrange them like this. 

What I can do is simply go over to the View tab and choose Arrange All. I have four different ways of arranging my workbooks. I can choose to arrange them vertically side by side. One click, on "Vertical," click OK. They're vertically side by side. 

Horizontal Arrangement 

I could choose to arrange them all horizontally, one on top of another. So this is the landscape version of arranging all. I could click Arrange All and choose to Cascade. If I choose Cascade, I see the most of each window, but I'm still able to see the other window just by clicking outside of my current sheet. 

Well, how do I get back to the sheet I was just looking at? Just go a little bit outside, over to the right, little outside, over on top. 

Tiled Arrangement

Now, let's say I'll create two extra windows. I'll use a keyboard shortcut to do that: Control N, Control N. I could go to View, and I can choose Arrange All.

One option we haven't looked at is Tiled. If I select that and click OK, Now my windows are arranged as if they're bathroom tiles. That's the analogy I'm using here. 

All right, so now I'm going to close that additional workbook too. Again, it's the same exact workbook. If I click on this tab, and I go here and start typing, it's the same exact workbook. Any edits I make in that sheet apply to the original. 

Keyboard Shortcuts 

But I'm going to close it for now and I'm just going to leave two windows open. Now I want to arrange these windows side by side, but I don't want to have to use Arrange All. I just want to use keyboard shortcuts. 

Now, this is the window that's currently up front. If I want to have this window take up half the screen, I can press the Windows key, press the right arrow key, and it takes up half the screen. 

What Microsoft will now do is show me the other available windows. Since I am doing a recording, it's showing me the software I'm using to record this video. But the other window that I want to take up the other second half of the screen — and I can use my arrow keys to navigate between the two open windows — is the Excel spreadsheet here. I'll press Enter. 

If I want that window that I just selected to take up the whole screen, I'll use the Windows key, up arrow. Now it's taking a quarter of the screen because there is another screen that could take up the other quarter down there. But I want full screen, so I'll press Windows, up arrow again. 

Let me just flip back to the original window, Windows key, up arrow. If I wanted to store down — Windows key, down arrow — and if I want to store all the way down, Windows key, down arrow again. That minimizes. 

If I want to bring it back, I'll press Alt Tab. Alt and Tab key allows you to cycle through the numerous open windows that you have. But if you do it quickly, you can go back and forth between any two windows. 

Let's say I go to my Camtasia window and I select that. If I just want to flip back between the Excel spreadsheets, the keyboard shortcuts, I can use our Control Tab. This will only switch between the two open Excel windows, or however many windows you have open in Excel. 

I want to control the position of this window, so I can press Windows key, left arrow. Takes up the left half. Windows key, right arrow, we'll move it towards the middle. And Windows key, right arrow moves over to the right side. Then I get to pick the other window I want to take up the left half. I'll use the blank Excel spreadsheet. I'll press Enter, and I just switched positions of the windows. 

Recap 

So these are quick little keyboard shortcuts you can use to navigate and manage windows inside of Excel.