how do i delete empty rows in excel?

[Guest]

e.g.:

B A O P
Q L P E
Q D L E

if i press Ctrl+End, it will jump to the E at bottom right corner
then
i delete the last row(entire)
and press Ctrl+End, it jumps to the empty space(previously the last "E")
how can I solve that problem?
thx a lot!

 

[Guest]

not using VBA, thx

 

[Guest]

Hi
Select last cell containing data move down one cell hold Crtl and shift keys
and press down arrow right click selected cells choose delete and select
entire row click ok.
You may have to save file and reopen before used range resets depending on
excel version