Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

CTRL-END question

Posted by PQ on January 28, 2002 1:31 PM

I have a sheet that had a formula and row 5000, but after tweaking it some the final row entry resides at row 3000. Unfortunately, now whenever I CTRL-END to get to the bottom I end up at row 5000. I'm sure there is an easy fix for this. Any suggestions?

Thanks,
PQ

Re: CTRL-END question

Posted by Marlin on January 28, 2002 4:22 PM

G'day,

Highlight all rows below 3000, then select EDIT, then DELETE. This should delete all formats/formulas from everything below your 3000.

Close the workbook, reopen it, then try Ctrl/End, if does not work, repeat the process.

HTH

Mark.

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.