Hi <
[email protected]>, (not very friendly for a name)
To be a little more specific as to why and how this happens.
Create a new sheet populating a few rows (four).
Select rows 2:4 then Insert (menu), rows
check the last cell (Ctrl+End)
delete any two rows
check the last cell (ctrl+End)
delete the extraneous rows
select 5:6, edit, delete rows
File, save
Check the last cell (ctrl+End)
The last cell reference gets moved down but does not fix itself,
this has been true in all versions of Excel at least from Excel 95.
Another cause of last cell problems are conversions to Excel
from other spreadsheets, and bad macros that process every cell
including those beyond the used range. Also be wary of cells
with hidden calculation in remote areas of worksheet -- I would
discourage this practice but watch out for it.
My web page on fixing last cell problems in Excel 95 and up is
Lastcell, Reset Last Used Cell
Reset All Lastcells in the Active Workbook (#resetall)
-- this method usually works and is very fast
http://www.mvps.org/dmcritchie/excel/lastcell.htm#resetall
Making the activecell the LastCell (#MakeLastCell)
-- this method always works and allows you reduce to the range
http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell