There are two techniques for jumping over blank cells to the next data cell in Excel:

The cumbersome technique:

1. Press Ctrl + F to invoke the Find dialog box.
2. Type an asterisk (star). The asterisk is the wildcard for any text. Press Enter to find a cell with text.
3. Cancel the search.
4. Press F4 to find again. 

You can use F4 as long as you don't change the search string in the Find dialog.

The complicated yet elegant technique:

Record a macro (Tools | Macro | Record New Macro) to perform this task, and assign a hotkey to do it. Store the macro in your "Personal Macro Workbook," not "This workbook." You will need to define a shortcut key at this time: Ctrl + a letter of the alphabet. The hotkey must be Ctrl + a letter, not a number or punctuation. When recording the macro, don't make typing mistakes: Type:

Ctrl F
*
Enter
Esc

To end the recording, choose Tools | Macro | Stop Recording. 

Too bad there isn't a default way to jump to the next data cell, but at least there is a workaround.

Alan

Alan Cantor
Project Manager
Strategic e-Government Implementation
e-Government, OCCS
416-212-1152
[log in to unmask]

>>> [log in to unmask] 10/10/02 11:48AM >>>

I would also think that Excel would have a built-in keystroke, like Lotus
and Quattro, to jump over blank cells to the next cell containing data.  If
such a built-in keystroke exists, then you have other screen reading
commands to determine where you have landed.