Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Sometimes you have more than one workbook open because you need to copy data from one notebook to another or sometimes you simply need to view data from different workbooks, different files, at the same time. It's not uncommon also to have 3 or 4 or 5 files open depending upon your working environment, and you want to be able to switch back and forth between them somewhat coherently too. Now, sometimes the approach is simply to view them all at once if you have only a few open. I've got two open for the moment. Why not simply go to the View tab and Arrange All? When you choose this make sure you uncheck the box for Windows of active workbook if you'd like to see different workbooks. Click OK.
So, that's fast and easy. You can change the zoom factor on either side as needed. If you are copying data, it's not a bad idea to see both of them at the same time. Now, if you have a third file, fourth file, fifth file open you can imagine how the screen space isn't quiet so efficient. When the view is like this by the way if you'd like to simply focus on one of these, for example the one on the right maybe, click the button to maximize this, and the other one is in the background. How do we get back and forth between the two? The standard way by way of the View menu is to Switch Windows, and we see the list of those that are open.
It's not a bad idea to go here once in a while anyway just to take stock of how many workbooks you do have open, but this is certainly okay and it works fine. A lot faster and particularly efficient if you have only two files open is Ctrl+Tab, back and forth a nice toggle when you have only two. You've got three or four it still works, but it will take you to the next file, the next file and back to the current one. If you'd like to create a new workbook, there certainly are command ways to do this, but Ctrl+N is pretty fast. Ctrl+N, new workbook. It will be called Book2, Book3 depending on which other workbooks you might have had opened recently.
So, here is Book4, and as I press Ctrl+Tab, we are back to this workbook. Ctrl+Tab again and Ctrl+Tab again. So, we can easily zip back and forth between them. If we were to arrange all of them here too that might make some sense. You might want to reconsider possibly Horizontal, Vertical. Tiled is the one I prefer. It usually works out best, click OK, but you can change that as you wish. This display here if you want one of these to be more prominent to get the line sure of attention. Click in that particular workbook and then press Arrange All again and that one will get the lion's share of attention.
Whenever there is an odd number one will be bigger than the others. So, good quick ways to zip around between open workbooks.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70691 Viewers
80 Video lessons · 127722 Viewers
52 Video lessons · 62580 Viewers
59 Video lessons · 48302 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.