Join Dennis Taylor for an in-depth discussion in this video Navigation shortcuts, part of Excel 2010 Power Shortcuts.
- View Offline
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.
- Creating charts with keyboard shortcuts
- Converting formulas to values by dragging
- Repeating Undo and Redo actions
- Displaying formulas instantly
- Navigating quickly through worksheets and across workbooks
- Formatting numeric, and date/time data in a flash with keystroke shortcuts
- Inserting dates or times instantly
- Grouping rows or columns to create collapsible regions
- Building data-entry shortcuts with Auto-fill
- Displaying unique items from large lists