Microsoft Office Tutorials and References
In Depth Information
Moving Around the Grid
Moving Around the
Grid
As you enter data, you may discover the Bigtime Excel Display Problem (known to
aficionados as BEDP): Cells in adjacent columns can overlap one another. Figure
14-7 shows the problem. One way to fix BEDP is to manually resize the column, as
shown in Figure 14-5. Another option is to use wrapping to fit multiple lines of text
in a single cell, as described on page 453.
Figure 14-7:
Overlapping cells can create big headaches. For example, if
you type a large amount of text into A1, and then you type
some text into B1, you see only part of the data in A1 on
your worksheet (as shown here). The rest is hidden from
view. But if, say, A3 contains a large amount of text and B3
is empty, the content in A3 is displayed over both columns,
and you don’t have a problem.
Moving Around the Grid
Learning how to move around the Excel grid quickly and confidently is an
indispensable skill. To move from cell to cell, you have two fairly obvious choices:
Use the arrow keys on the keyboard . Keystrokes move you one cell at a time
in any direction.
Click the cell with the mouse . A mouse click jumps you directly to the cell
you’ve clicked.
As you move from cell to cell, you see the black focus box move to highlight the
currently active cell.
In some cases, you might want to cover ground a little quicker. One option is to use
the scrollbars at the bottom and on the right side of the window to scroll off into
the uncharted regions of your worksheet. Excel also provides two more powerful
features—shortcut keys and the Go To feature—which are described in the
following sections.
Shortcut Keys
Excel provides a number of handy key combinations that can transport you across
your worksheet in great leaps and bounds (see Table 14-1). The most useful shortcut
keys include the Home key combinations, which bring you back to the beginning of
a row or the top of your worksheet.
Note: Shortcut key combinations that use the + sign must be entered together. For example, “Ctrl+Home”
means you hold down Ctrl and press Home at the same time. Key combinations with a comma work in
sequence. For example, the key combination “End, Home” means press End first, release it, and then press
Home.
 
Search JabSto ::




Custom Search