Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

moving to the top of a column

Posted by Jerry Malloy on December 21, 2000 10:29 AM

How does one get to the top of a column.

I work with large spreadsheets and as far as movement, I know that Cntl+ Home takes you to the beginnging of a worksheet and home takes you to the beginning of a row but what takes you to the beginning of a column?

example : I just finished editing data at j25733....now I want to position myself at j1

Can anybody help?

Re: moving to the top of a column

Posted by Paula on December 21, 2000 10:38 AM

A couple of easy ways to move around are to use either the Go To function or the Name Box. The Go To function is available on the Edit menu or by using Ctrl + G. To use the Name Box, click in the Name Box and type in the cell that you want to go to, then hit Enter.

Re: moving to the top of a column

Posted by Tony Scala on December 21, 2000 10:39 AM

Place cursor on toop border of j25733 and double click. This will move you to the top of the column. this works to the left and right. Also can use "end" arrow up,down,left,right. TS

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.