How to Navigate through shortcuts in Excel. Follow this step by step tutorial to learn how to navigate using shortcuts between multiple Workbooks in Microsoft Excel
Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/103440382717658277879 - our group in Google+
Microsoft Excel has multiple sheets in a workbook but sometimes people have to work on more than one workbook and switching between them again and again becomes a problem. In this tutorial we will show you some shortcuts through which you can work on more than one sheet with ease using Excel shortcut keys.
Follow this step by step tutorial to learn how to navigate shortcuts in Excel.
Step # 1 -- Press 'Arrange All' button
In this tutorial you can see that one workbook is already opened and we will open another workbook. If you want to work on them so the first step is to go to the "View" tab and click on the "Arrange All" button. A small box will open, click on the radio button of "Tiled" and press the "OK" button.
Step # 2 -- Work with two Workbooks at a time
When you press the "OK" button, the two Workbooks will be opened side by side. You will be able to work on both of the Workbooks. You can copy data from one Workbook and paste it in the other one or zoom in or out. Working this way is easy and you can look at both of the sheets simultaneously.
Step # 3 -- View another Workbook
In order to switch between windows go to the "View" tab. On the right side of the screen you will able to see "Switch Windows" button. Click on that button and a drop down list will open. This list will contain the names of the sheets which are currently opened. Click on the sheet name, the one which you want to switch to and it will open. There are two shortcuts in Excel for switching windows. The first one is that you can press "Ctrl + F6" and the second one is that you can switch by pressing "Ctrl + Tab".
Step # 4 -- View three Workbooks at a time
So far we know how to deal with two Workbooks at a time. If you want to add another sheet, this means a third sheet, it's going to get a bit tricky if you don't know the trick. Another Excel shortcut key is "Ctrl + N" used to open a new Workbook, when the sheet is open, Go to the "View" tab and click on "Arrange All" button and press "OK". All the three Workbooks will be opened together. Two of them will cover half of the area and will be displayed on the right side. The third one will be displayed on the left side and it alone will cover the rest of the area. The Workbook which was last opened or the workbook which you were on will be displayed on the left side. If you want some other workbook to be displayed on the left side then click anywhere on that workbook and press the "Arrange All" button.
Tags: How to Navigate through shortcuts in Excel, 000947, How, to, Navigate, through, shortcuts, in, Excel