1-866-245-5224 sales@keystonelearning.com

Excel 2003: Navigation &Selection;Techniques

Excel 2003: Navigation &Selection;Techniques

Excel 2003 navigation is probably much easier than you think. In fact, Excel 2003 uses many of the same commands that other Microsoft Office programs do. So, think of this like a Two-for-One deal. If you learn navigation in this program, you’ll automatically gain knowledge you can apply to other programs, as well.

Mastering the art of navigation will allow you to complete your work faster. To aid in this, you’re going to learn navigation by using both the mouse and keyboard. And, selecting cells is the key to being able to format, move, copy and otherwise enhance your worksheets. For cell selection, you’ll also learn techniques that use the mouse and the keyboard (some of the techniques even require you to drive with two hands by using the mouse and the keyboard together).

Mouse Navigation Techniques

               

To Move…

Click…

Up One Row

Up Arrow on Vertical Scroll Bar

Down One Row

Down Arrow on Vertical Scroll Bar

Right One Column

Right Arrow on Horizontal Scroll Bar

Left One Column

Left Arrow on Horizontal Scroll Bar

Up One Screen of Information

Blank Area of the Vertical Scroll Bar Below the Up Arrow

Down One Screen of Information

Blank Area of the Vertical Scroll Bar Above the Down Arrow

Right One Screen of Information

Blank Area of the Horizontal Scroll Bar Left of the Right Arrow

Left One Screen of Information

Blank Area of the Horizontal Scroll Bar Right of the Left Arrow

 Keyboard Navigation Techniques

               

To Move…

Press…

Up One Cell

Up Arrow

Down One Cell

Down Arrow

Right One Cell

Tab or Right Arrow

Left One Cell

[SHIFT]+Tab or Left Arrow

Up One Screen of Information

Page Up

Down One Screen of Information

Page Down

End of Row Data

[End]

Beginning of Row Data

[Home]

First Cell in Worksheet

[CTRL]+[Home]

Last Cell in Worksheet Area

[CTRL]+[End]

 Mouse Selection Techniques

               

To Select…

Click…

One Cell

The Cell

Multiple Cells

Click & Drag (with the left mouse button)

Row

The Row Heading (Number)

Column

The Column Heading (Letter)

Entire Worksheet

Select All Button (upper-left corner of worksheet)

 Keyboard Selection Techniques

               

To Select…

Press…

Continuous Cells

[SHIFT]+Arrow Keys

Entire Worksheet

[CTRL]+A

 Mouse/Keyboard Combination Selection Techniques

               

To Select…

Click & Press…

Non-Continuous Cells

[CTRL]+Left Click