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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!