LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002: How to eliminate space within a cell and count items? Mr. Low Excel Discussion (Misc queries) 6 November 24th 06 01:53 PM
Excel should merge cells without removing content of any cell Rumpa Biswas Excel Discussion (Misc queries) 14 January 1st 06 12:32 AM
Can I copy a combo box in Excel 2002 with a relative cell link? Bozo Excel Discussion (Misc queries) 1 February 17th 05 02:05 AM
excel tab key to move to right adjacent cell dwillie Excel Discussion (Misc queries) 2 January 26th 05 08:01 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"