View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Excel 2002 : How to move to the next cell with content ?

Try CTRL + down arrow.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mr. Low" wrote:

Dear Sir,

I am a new user of EXcel 2002 and not familiar with the keyboard short cuts.

Let consider the worksheet below :

Row A B C

1 xxx xxx
2 xxx xxx
3 xxx xxx
4 xxx xxx

12500 xxx xxx xxx
xxx xxx
xxx xxx
16250 xxx xxx xxx



May I know how to move down a column of blank cells from C1 to the next
filled cell at C12500 ?

I tried to use END and Downward Arrow key, but the cursor moved to the
C16250 the last cell at the last row of the worksheet. For your information
the column C was a formulated column that was converted to values.

END and Arrow key work very well for normal cells which are not converted
from formulas to values but not in Column C. Is there anything I could do to
column C to make it normal ?


Thanks

Low


--
A36B58K641