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 last line of the active worksheet

Dear Sir,

I need to copy a formula from cel C1 to C1680 (the last line) in folowing
worksheet:

< There are no spacing between rows

A B C D
1 xxxxx xxx xxx
2 xxxxx xxx xxx
3 xxxxx xxx xxx
4 xxxxx xxx xxx
5.. xxxxx xxx xxx ...
.....
1293 xxx xxx xxx


Column C is blank, if I strke CTRL END it would go to the end of the
Worksheet at C65536.

If I strke CTRL SHIFT END it would block up C1:I1600.

May I know is there any key board shortcut to highlight column C from C1 to
C1293 only ?


Kind Regards

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
Export from OL to Excel with 2 line addresses question Judy Excel Discussion (Misc queries) 0 December 11th 06 08:47 PM
Excel 2002 Add-in: Open Database Connectivity available for Excel Nick B Excel Discussion (Misc queries) 8 December 7th 06 06:04 PM
macro- move down to empty cell & active worksheet EducatingMom Excel Worksheet Functions 3 August 4th 06 11:02 PM
How can I move the active cell in Excel with the arrow keys? Chuck T Excel Discussion (Misc queries) 3 December 12th 05 03:38 PM
excel 2002 - copying formulas to another worksheet Greg Excel Discussion (Misc queries) 2 January 28th 05 10:23 PM


All times are GMT +1. The time now is 01:14 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"