Visit Debra's site at
http://www.contextures.com/
She tells how to do just that
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"akkrug" wrote in message
...
Is there a way to reset the end of a spreadsheet to the last cell that has
information in it? When I press End Home, I am landing on row 6,448 even
though I selected rows 500 - 6448 and hit delete. Also, another basic
question. Sometimes a range of cells will increment to the next value and
sometimes they won't. Is this just due to formatting differences in the
cell?

Thanks.

Ken K. - 2191
--
akkrug