Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

S ELECTING A C ELL USING THE K EYBOARD  D ISCUSSION

When you open Excel, a blank workbook appears in the application window. You will notice a thick green border around the first cell in the upper left corner of the worksheet. This cell is known as the active cell. When data is entered, it appears in the active cell.

Each cell has an address. The address for the cell in the upper left corner is A1. When A1 is the active cell, the column heading, the letter A, and the row heading, the number 1, are both highlighted. The address A1 appears in the Name box, located on the left side of the formula bar, just above the column.

You can use the keyboard to select a cell and make it the active cell. When you press certain arrow keys or a combination of keys, the cell pointer moves to a new cell, making it the active cell.

NOTE When you open a new, blank workbook, the active cell is always cell A1.



P ROCEDURES

1. Press [ ] to move one cell down.

2. Press [ ] to move one cell to the right.

3. Press [ ] to move one cell up.

4. Press [ ] to move one cell to the left.

5. Press [Page Down] to move down one screen.

6. Press [Alt+Page Down] to move one screen to the right.

7. Press [Page Up] to move up one screen.

8. Press [Alt+Page Up] to move one screen to the left.

9. Press [Ctrl+Home] to move to the upper, left cell in the worksheet.

Page 34

OFFICEPRO, Inc.