Control + End

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dveenhuis - 22 Oct 2004 00:25 GMT

I frequently start with a large spreadsheet, filter out many of th
rows, and end up with a smaller spreadsheet that I will work on for
month. I like to use "control + end" to go to the last cell in th
sheet, however, it now takes me to the last cell of the original sheet
I've tried deleting, clearing, rows but nothing seems to work

Reply to this Message

Dave Peterson - 22 Oct 2004 01:33 GMT

Visit Debra Dalgleish's site for some tips:

http://www.contextures.com/xlfaqApp.html#Unused

> I frequently start with a large spreadsheet, filter out many of the
> rows, and end up with a smaller spreadsheet that I will work on for a
[quoted text clipped - 7 lines]
> dveenhuis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15576
> View this thread: http://www.excelforum.com/showthread.php?threadid=271400

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

Ed - 22 Oct 2004 02:33 GMT

dveenhuis:

The method I use is:

Delete all "empty" rows below your new last row.
Delete all "empty" columns to the right of your new last column.
Make the active cell somewhere above your last row and to the left of your
last column (I use A1).
Save and close the workbook.
Reopen the workbook.

This works in Excel 97, 2000, and 2003.

Good luck,
Ed

> I frequently start with a large spreadsheet, filter out many of the
> rows, and end up with a smaller spreadsheet that I will work on for a
> month. I like to use "control + end" to go to the last cell in the
> sheet, however, it now takes me to the last cell of the original sheet.
> I've tried deleting, clearing, rows but nothing seems to work.

Reply to this Message