MrExcel Publishing
Your One Stop for Excel Tips & Solutions

navigating in a worksheet

Posted by Bernadette on February 05, 2002 5:29 PM

When using the Ctrl + End key to go to the end of my data in a worksheet, the selected cell is moving to the end of the worksheet row 65536. How can I make it go to only the end of the data. I know it is really simple but I cant find it.

Posted by Tom Urtis on February 05, 2002 5:51 PM

Try simultaneously pressing Ctrl+Shift+arrow (up, down, left, or right). This will take you to the last contiguous cell (relative to your active cell) that contains data or a formula in that respective row or column.

Tom Urtis

Posted by Chris D on February 06, 2002 12:30 PM

similarly, if you want to do it just using your mouse....

the current selected cell has 4 borders

hovver your mouse over either of the borders and it will change from a square cross (+) to an arrow

double click on this border and it will roadrunner to the end of the contiguous range whether up, down, left or right.

always useful...