I am have a problem with spreadsheets in general, regarding the default area of a worksheet. If I have 300 rows of data in a worksheet (with columns A to M filled), and press CTRL & END, the cell selected is the bottom rightmost cell on row 300 ie M300. If I now delete 150 rows in the middle & press CTRL & END it still selects M300, even though the last data is now M150. This might seem trivial, but when using pivot tables to analyse data the rows may vary between 20 & 30,000 and scrolling takes for ever.
Hope some one out there can help!
Cheers John Woolliscroft