Empty cell deletion at bottom of worksheet

[DarCady]

On some of my worksheets, the slider bar on the right has become a small square rather than a long rectangle. This causes this slightest shift downward to jump through large amounts of rows. Excel seems to think there must be data down there I need. How do I get rid of empty cells at the bottom of a worksheet so that this no longer happens?

[shg]

Select the first empty row below your data, do Ctrl+Shift+Down Arrow, Edit > Delete.

[JP Romano]

I use the code below to do it in multi-sheet workbooks. If you have Excel 2003 or earlier, you'll need to change "a100000" to "A65536"

Please Login or Register  to view this content.