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

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

Hello Dave,

I tried CTRL + down arrow, but it did not work.

The cursor moved to the last cell in the last row.

Is there any other solutions ?


Thanks

Low


--
A36B58K641


"Dave F" wrote:

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