Subtitles of the Movie

When working in spreadsheets it's important to learn the various methods for moving between and selecting cells. In this lesson, we will explore navigation using the keyboard and the mouse. Clicking any cell with the white cross will select that cell. You can check in the name box to verify your location on the worksheet. The column letter and the row number for the cell will also highlight. The scroll bars can be used to locate rows and columns beyond the current viewing area on screen. At times we'll need to make changes to a group of cells. To select a group or range of cells, click and drag with the white cross. As you can see, the selected cells are highlighted in a bluish colour surrounded by a black outline. To deselect that range, click once on any cell on the worksheet. To select and entire row or column click the button that labels that. For example, to select all of column C, I can click on the letter C button and it selects the entire column all the way to the bottom. To select a row I can click on that rows number. And another method for selecting a range, is by using the shift key on your keyboard along with the mouse. For instance, if range B3 through E12 should be selected, click once in cell B3. Then holding down the shift key on your keyboard, find and select cell E12. This selects all the cells in between those two. Like the shift key, the control key can be used with the mouse to select multiple cells. While holding control, click in various cells around the sheet. This will allow you to select cells throughout the sheet that are not part of a continuous range. If you prefer to keep your hands on the keyboard, there are methods of navigating and selecting cells using only keystrokes. To move one cell at a time in any direction use the arrow keys. If you use the arrow keys on the number pad, make sure your number lock is not turned on. The enter or tab keys will also move one cell at a time. Enter will move down, and tab will move to the right. To move in the opposite directions, simply hold down the shift key while pressing enter to move up. Hold down shift and press tab to move to the left. Some keys are available that will move you more than one cell at a time. For instance, the page down key will move one full screen full of rows down the page. Notice that row 20 is currently at the bottom of my screen. When I hit page down, row 21 begins at the top. Page up, will take you back up, one screen at a time. Other keystrokes are available. For instance, by pressing the end key once and then hitting the right arrow key, I can move to the very last column in a worksheet and similarly to the very last row by pressing end and the down arrow once. To move back to the very top of the worksheet, hold down the control key and press home. This will always take you back to cell A1. To select a range of cells, hold down the shift key and use the arrow keys to move in the direction that you want to select. As you move down with the arrow keys, more rows will become highlighted, as you move right with the arrow keys, more columns will become highlighted. You can then use the left arrow keys and the up arrow keys to deselect groups of cells. These are some of the basic keystrokes used for navigating Excel. To find out more about using keystrokes, search the help screens. These are some of the basic keystrokes used for navigating Excel. To find out more about using keystrokes, search the help screens.