MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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.