The problem: In excel if I have 100 rows and 5 columns and I press Ctrl+End it will take me to cell E100. If I then delete some rows and columns and press Ctrl+End it will still take me to cell E100.

Does anyone know the way to set what the data area is? There was a way to do this and it's probably still done the same way, but I can't remember what it was. I was thinking I assigned the area a name. I was thinking it was similar to how the cell range "print_area" is named when you set the print area. The assistant has been no help (bad dog or paperclip as the case may be).

This is not just inconvenient. It's makes me have to put a subtotal in cell E101 in order for the auto filter to not hide it when active.

Thanks