Excel 2002 : How to move to the next cell with content ?
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 |
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 |
Excel 2002 : How to move to the next cell with content ?
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 |
All times are GMT +1. The time now is 11:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com