Quickly move to the end or beginning of big chunks of data.
Excellent trick when you should have Master/Detail lookup combo box in your Excel form. This is quite often needed. Here is an example:
While creating complex Excel based data input forms many cells needs to be protected from user input, like input labels, table titles, etc... When giving form to production I must be sure that all cells are properly locked. But, how to be sure if this having 1000+ cells ?
I discovered simple and visual technique to quickly detect and show locked and unlocked cells using Excel 2003 or 2007/2010.