In a worksheet

One possibility to navigate between the different cells in a worksheet is by using the arrow keys on your keyboard.

Another possibility is to use the “END” button and the “HOME” button on your keyboard.
The “Ctrl + END” shortcut brings you to the far right and bottom cell in the “Worksheet” .

The “CTRL+ HOME” shortcut takes you to the leftmost and topmost cell in the “Worksheet” .

The “PAGE UP” and “PAGE DOWN” keys on your keyboard moves the window one page up or down.

Keeping the Alt key on your keyboard pressed, moves the window to the left or right

Holding down the Ctrl button while using the down arrow takes you to the bottom cell of that column in which data is shown. Condition for this is that all cells in the column should contain data. If this is not the case, only the most recently completed “Excel” cell for that column is shown.

The same goes for the Ctrl + up arrow keyboard shortcut .

Another way to navigate to the bottom cell is by double-clicking the lower edge of the selected cell. And the same way for the top, the left edge, right edge. Again, the rule is that “Excel” will stop when it encounters a blank cell.

If you wish to navigate quickly to a specific cell, type the cell name in the ‘Name Box” (1) and press the ‘Enter’ key on your keyboard. Or else press the F5 key on your keyboard, type the cell name in the dialog that appears (2) and click the OK button.

Between different worksheets

To navigate between “Worksheets” in our “Workbook”, we obviously can click on the tabs. However, if you have created a lot of “Worksheets”, there is an easier and much quicker way to select a “Worksheet”. Click right above on one of the arrows (1) at the bottom left of the application window. This opens a pop-up (2) where all the “Worksheets” in our “Workbook” are listed. Select the “Worksheet” that you want to access.

When you want to navigate to the next “Worksheet” , you can use the “CTRL PAGE DOWN” shortcut on your keyboard.
If you want to navigate to the previous “Worksheet”, click the “CTRL PAGE UP” shortcut on your keyboard.

If you want to add a new “Worksheet”, click the “Insert Worksheet” (1) button.

However, if you want to add a “Worksheet” between two existing “Worksheets”, select the “Worksheet” and you click the Shift + F11 shortcut on your keyboard. This will add a “Worksheet” on the left of the selected “Worksheet”.

Between different workbooks

Sometimes it happens that you have more than one “Workbook” open. For example, when your information has to be copied from one “Workbook” to another, it is useful that we have separate files beside or below each other in a new window.

To do this, select the “View” (1) tab and click the “Arrange All” (2) button.
In the “Arrange Windows”, dialog (3) choose an option, in this example side by side, and click the ok button (4). Now it is easy to copy information from one workbook to the other.

If you wish to open several worksheets of a “Workbook” in another window, select the various “Worksheets” one by one and you click on the “New Window” (5) button in the “Ribbon”. When all “Worksheets” have been opened in a new window, you can arrange them just the way that I have discussed above, but now you select the “Windows of active workbook” (6) option in the “Arrange Windows” dialog.

Another way to navigate between open “Workbooks” is by clicking on the “Switch Windows” (1) button option in the “Ribbon”.

This opens a drop-down menu (2) where all open “Workbooks” are listed.

One last way to navigate between different open “Worksheets” is the “Ctrl +TAB” shortcut key on your keyboard.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats